469,112 Members | 2,010 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,112 developers. It's quick & easy.

SQL Server 2000 Trusted connection

I am trying to connect to a sql server database from enterprise
manager. I am using sql server authentication and have set the SQL
Server up to accept mixed mode authentication. I am still get the
message : Login failed for xxx. Reason not associated with a trusted
sql server connection.
Jul 20 '05 #1
1 4933
Hi, Vicky.

"Trusted" refers to your domain based login that this protocol
expects. You might temporarily delete your SQL-based login and re-add
your "trusted" ID or the group it is a member of in the domain to test
this functionality.

You can troubleshoot this by putting a trace (SQL Profiler) on to see
where the authentication fails and what exact message is responsible
for the failure.

Is it possible that you have different passwords between your SQL
account and your domain-based account? If not, try setting them to the
same code.

If you enable more TCP/IP and Named Pipes for both the client and
server and try again, it will probably allow you to pass the check by
authenticating somewhere. I only suggest this if you are stuck.

Hope this helps or gives you some options.

--Steve
st***@strategic-pc.com
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Ray Valenti | last post: by
4 posts views Thread by Robert | last post: by
17 posts views Thread by Danieltbt05 | last post: by
22 posts views Thread by Bob and Sharon Hiller | last post: by
4 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.