This issue pops up occasionally here. I tell the developer to reboot his or her machine, and it clears up. It happens to us mostly when the user hasn't rebooted in weeks.

Robert Davis
<mailto:[Email address protected]

________________________________

From: Sizo Male [mailto:mssqldba-ezmlmshield-x43358712.[Email address protected]
Sent: Sun 10/30/2005 10:12 AM
To: LazyDBA Discussion
Subject: FW: ODCB Connection Error SQL Server Error: 18452




> Hi All!
Note: this happens when I use Windows NT Authentication.
When I use SQL server authentication it works fine with.

> I have this situation:
>
> I have this server that I setup on Windows Server 2003 and running SQL 2000 Server.
>
> Now when I try to connect to an application running on this server on SQL from a client machine running Windows 2000 prof Service pack 4,
> using ODBC connection with TCPIP I get this error message:
> ===================================================================================================
> 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
> ===================================================================================================
>
> I will keep searching the net as well.
>
> Note: When I use Named pipes connection it works.
>
> Your help in this regards will be very much appreciated.
>
> Thanks
> Sizo Male
>
>
>
>
>


------------------------------------------------------------------------------------------
This e-mail was checked by the e-Sweeper Service.
For more information visit our website, Clearswift Corporation e-Sweeper :
http://www.mimesweeper.com/products/esweeper/
------------------------------------------------------------------------------------------



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page