I've checked the posts and I think i'm missing something very small. Trying to connect to the database with a username/password. I'm running the MSDE version of SQl on W2k3.

Error is Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

I thought I would just use the sa account with the password I set during the database create. Not working. when I try to use dbconn.udl as someone requested in an earlier post, I can connect using Windows NT Integrated Security. But not with username.

Can I change my database connect string to use integrated, or do I need to create and associate a username/password with the databsae I created. If so how?

Thanks for the help.

-Gary

I did some more checking and saw on http://www.connectionstrings.com how to set the connection string correctly.

But now i'm getting the error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

I tried setting the permissions on the c:\windows\temp directory as listed in another post and that didn't help.

Any help is appreciated.

-Gary

 

http://aspdotnetexpert.blogspot.com/2008/06/login-failed-for-user-sa-reason-not.html