Connection Error 18452 - Login failed for user '(null)'

From: Markus Wolff (mwolff_at_muffin.de)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 09:17:35 +0100

Hello everybody,

one of our users gets an error message when trying to connect to our SQL
Server database:

Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection.

The problem occured suddenly during work. The user can connect to the server
using another computer and other users can connect using his computer.
Knowledge base didn't help so I'm asking you.

Configuration
Client: Windows XP professional (2002/SP1)
ODBC driver: SQL Server (2000.81.9042.00)
Client configuration: TCP/IP

Server: Windows 2000 Server
SQL Server 7.0

Seems the network setup for the user is somehow corrupted, since the message
states the user to be '(null)'.

Any suggestions?

Thanks in advance,
Markus Wolff

Relevant Pages

  • c++ application causes an error
    ... The program was written to connect to a microsoft SQL server 7.0 database ... either my windows 95 or windows 98 box, I get the following error message: ... Is there some way to fix this error message with a patch or update of the ...
    (microsoft.public.vc.database)
  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... I suppose there might be legal reasons why Microsoft ... > SQL Server 2000 SQL Scan Tool ... > computers running Windows 2000 or higher and can identify instances ... > error message text received, ...
    (microsoft.public.sqlserver.security)
  • RE: Any SQL Server 2000 and XP SP2 issues?
    ... Some programs seem to stop working after you install Windows XP Service ... computer that is running Windows XP Service Pack 2 ... "You may not be able to connect to an instance of SQL Server, ... you may receive an error message that is similar to the following: ...
    (microsoft.public.sqlserver.server)
Loading