19 Ekim 2005 Çarşamba 14:17We are trying to link an SQL2K server (Running in mixed mode) to an SQL2K Server (Running in Windows only mode).
In the properties I have tried putting (in Local server to Remote server mappings on the security page)my own dm\JohnDoe to dm\JohnDoe as both servers are in the same domain. In Enterprise Manager I can view all databases using my windows authentication - I have checked the Registration properties and both are set to Windows Authentication..
We get the error 'Error 18456: Login Failed for user 'NT Authority\Anonymous Logon'.
Please could anybody help with the setting up of this, we are running out of time.
19 Ekim 2005 Çarşamba 17:56
Can you please provide more details of your setup?
1. The linked server settings that are used in the setup. If the linked server was created using a script, can you provide it?
2. The sql statement that is causing the issue
3. The local login that is used when executing the script
20 Ekim 2005 Perşembe 07:30
I am doing it in Enterprise manager: Security\Linked Server\servername
When you go into properties of the servername their is a security page.