View Single Post
  #1 (permalink)  
Old 02-14-02, 16:13
jlemonds jlemonds is offline
Registered User
 
Join Date: Feb 2002
Posts: 1
Question Intermittent - Login failed for user '(null)'

When trying to connect to a SQL 2K box running on Win2K adv server sometimes/some users report difficulty connecting. If they change from Windows authentication upon connecting to the server and instead use SQL authentication they can successfully connect.
We have other SQL servers on the same subnet that does not have this problem at all.

Env: Win2K Adv server SP2
SQL 2K Ent SP2


The message is as follows:
Unable to connect to server XYZ:
Server: Msg 18452, Level 16, State 1
[Micorsoft][ODBC SQL Server Driver][SQL Server]Login filed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.


Again: Windows Authentication - intermittently fails
SQL Authentication always works.

Note: Users exist in different domain than the machines, but this does not seem to effect the test or dev servers (naturally, only production have we seen this problem).

Any help is greatly appreciated.

thanks,
John
Reply With Quote