> 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/
------------------------------------------------------------------------------------------


MS Sql Server LazyDBA home page