471,893 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 5008
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.

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.