I.W Coetzer


Hi

Last week I was receiving an error when trying to connect to two of our seven sql servers from my laptop via my domain admin account. The only fix was to have my laptop rebuilt and everything re-installed.

Today however another administrator is starting to have the same problem but to only one of the seven servers!

When that administrator uses my laptop with her domain admin account it works!

What could possibly be going wrong with our laptops We have not installed or changed anything.

The full error message we see:

Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft Sql Server, Error: 18452)

The error being logged on the server: (two errors are logged each time)

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 53.35.165.148]

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 53.35.165.148]





Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

Madhu K Nair


The SQL Server seems to be configured for Windows Authenticaiton and you are trying to connect to the server using SQL Login. Either Change the AUthenticaiton mode to Mixed Mode or Connect using your domain account

http://support.microsoft.com/kb/555332

Madhu







Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

I.W Coetzer

Hi

No, we are trying to connect using our domain accounts which we always use.

It is already set up using Mixed mode, that is because our applications use Sql accounts but we use our domain accounts to administer the servers.

Bye







Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

Madhu K Nair

Check if this is the issue ...

There is a space after server name in the connection string

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

Madhu






Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

I.W Coetzer

Hi

I also found that post, but no there is definetely not a space after the server name in Sql Server 2005 Management Studio which the developer is trying to use when connecting to the server.






Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

Madhu K Nair

Since the servers are already in Mixed mode, could you please try to connect using sql login and post back the result. If you are able to connect using SQL Login, then one thing is sure the server is configured for remote connection.

Madhu






Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

I.W Coetzer

Hi

O, yes these servers that the one administrator cannot connect to are production servers! they are being used constantly.

We have many Sql 2005 servers being used by asp.net, .net, delphi etc. applications

Myself and another administrator can connect to the server, but the third administrator cannot anymore.

Don't forget what I mentioned in my first post - that i had the same problem last week, and determined that it was my laptop because I could connect using another laptop with my network id so I had my laptop formatted and all the software installed again - which resolved the problem, but now that the second administrator is experiencing the same problem we decided to try and find out via forums if this is a common problem.

Strangest thing is that I could not connect to 2 of our 7 servers via sql management studio

and she (the 3rd admin) can not connect to 1 of the 7 servers which is a different one! via sql managet studio with exactly the same error message and same 2 logs being logged on the actual server.

Bye






Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

Simon Facer

Did you find a resolution I'm having the same problem - I can connect to two intances on a Win 2003 / SQL 2000 cluster, but not the third.





Re: Login failed for user '' ..... Sql Server, Error: 18452 (The user is not associated with a trusted SQL Server connection)

I.W Coetzer

Below are two solutions that worked on two separate administrators laptops - to resolve this problem ...

Solution 1: Format / Re-Build your laptop ...

Solution 2: Control Panel -> User accounts -> Advanced Tab -> Manage Passwords (remove all items in there)