Login failed on a SQL database

  • Thread starter Thread starter Sorin Sandu
  • Start date Start date
S

Sorin Sandu

I have this connection string "data source=SRVSQL;initial
catalog=Domain\test;password=passw0rd;persist security info=True; user
ID=test;packet size=4096".
With this I get Login failed for user Domain\test.
If i use Trusted connection and I am logged with user test works.
If I use a SQL user works.
ODBC connection same error.
 
Hi
From what i remember from my sql server programming inital catalog should be
the name of the database in the sql server that you want to access.
You should also check in sql server security that the user test has access
to the database.

Tor Arne Gjelhus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top