servers

Dear all

We have 2 Servers with SQL Server 2000 and the linked servers between them are working properly. But when a client ( in windows authentication mode) wants to run a query, he will get the error :"Login Failed for user '(null)' : not associated with a trusted SQL Server connection"

I have tried to map the user and impersonate it but it doesn't work either.

Thanks in advanced

You can′t pass a SQL User when using WIndows authentication. Seems that you are either running in a SQL Server authentication connection or your client can′t pass its securities credentials.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de