Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

SQK2K - Linked server security.

We 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 owndm\JohnDoe todm\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.

Regards
John.

[715 byte] By [Newsco] at [2008-2-14]
«« VSS Add-in Missing after Installation
»» call function from second form
# 1

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

Thanks,
Rakesh

RakeshGujjula at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
# 2

I am doing it in Enterprise manager: Security\Linked Server\servername

When you go into properties of the servername their is a security page.

Regards
John.

Newsco at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified