I'm getting the following error when I try to connect to MSDE from my web app:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'User'.

However, I can login via Enterprise Manager with the User I have created with no problems.

The user has been setup with all the appropriate permissions, etc. It's an SQL Server login and the server is running in Mixed mode.

The connection string I'm using is:

DSN=CorpEventsSQL;Uid=User;Pwd=;Password;Trusted_C onnection=yes

Now, as far as I can tell, there's absolutely nothing wrong with that string so I'm stumped!

Have I missed something?

Hi there,

There *is* something wrong with the connection string: you have Trusted_Connection=yes in there. With that setting the database is accessed in the context of the calling user (for example, the IUSR_MachineName account) and NOT with the user name and password from the connection string.

You should change your connection string to something like:

DSN=CorpEventsSQL;Uid=User;Pwd=;Password

For more info:

http://www.connectionstrings.com/
http://www.connectionstrings.com/?carrier=dsn

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Ok, I've now removed that, but I still have the same error.

Could it be an incorrect password after all?

Or maybe User has the right password, but no access to the database defined in the DSN? Try renaming your user, and see what happens. Also, if possible, try replacing the DSN file with a "proper" connection string.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.