Connecting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: andrewnichols (anonymous_at_discussions.microsoft.com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 06:56:06 -0700

Hello All:

I have installed MSDE, using Windows Authentication. I can connect to it from a Query GUI tool I downloaded, which has an automatic option of NT Authentication. It does not ask me for a user, and has the password (too long to be my password) already written in. I cannot connect using anything else, including Andrea Montanori's DbaMgr2k. I get a msg:

Login failed for user 'sa' Reason: not associated with a trusted SQL Server Connection.

I am running this on Win XP.

I know I can add users for specific databases, but I think I should be able to log in with 'sa' and the password. Am i getting my own password wrong?

Thanks.

andrew.

Quantcast