Rob (th************@yahoo.com) writes:
On MS-SQL 2k I have a created user. Security for the SQL instance is
set to mixed.
When I attempt to connect to SQL using Enterprise client on another
machine on the local network using Windows Auth I get the error: DB
Name-Login Failed for user ('null')- Reason: Not associated with a
trusted SQL Server Connection.
What am I over looking?
Have you granted access to SQL Server for the user under which you
are logged into Windows? You do this by granting access directly
to the user, or a group of which it is a member.
If you have, there might be some trust problems in the domain. This is
particularly likely, if you don't have a domain, but only a workgroup.
--
Erland Sommarskog, SQL Server MVP,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp