Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

From: Egbert Nierop \(MVP for IIS\) (egbert_nierop_at_nospam.invalid)
Date: 05/04/04


Date: Tue, 4 May 2004 08:24:34 +0200


"Peter Afonin" <pva@speakeasy.net> wrote in message
news:uv2RYZTMEHA.2500@TK2MSFTNGP12.phx.gbl...
> Hello:
>
> I've just upgraded Windows 2000 server to Windows server 2003, and after
> this I cannot get to the SQL server Enterprise manager, I'm getting error
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection"

null points to an anonymous user that tries to login. In a (default) Win2000
is anonymous login easily possible. In Win2003 not.

Another thing to look at, is your client configuration (see SQL menu). It
might be that you use the wrong protocol such as TCP/IP while it needs named
pipes.