Cross server authentication issue

  • I have two linked SQL 2000 servers and users use Windows Authentication to access them (servers and users in the same domain). However when users try to run a sql script on one server that references a table in the other server they get the error message 'NT AUthority\Anonymous Logon'. MSDN suggested that it was due to the "\" in the domain\userlogon windows authentication and so I replaced with an alias username. Can anyone shed any light on this problem?

  • Is the linked server set up to pass through credentials? Or impersonate?

  • Thank you for your response.

    Login connections are made using the login's current security context and are not specifically defined in the local server login to remote server login mappings list.

    I've been looking at delegation - is that relevant. We are running SQL2000 SP4

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply