I have a SQL 2000 Server running on Windows 2003. The server is a secure internal build, and I must confess I don't have full visibility of all the security elements that have been performed at the OS level, but for the SQL server, I do have.
I have added my account as a Sysadmin login to the server (e.g. DOMAIN1\USER1).
Now when I run Query Analyser from a client logged on as DOMAIN1\USER1, I receive the error:
Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
It's as if my domain credentials are not being passed across to the server.
Thanks in advance.