I can't create a linked server when the same two servers are set up for replicatation. I get 'Error 15028: The server 'SERVERNAME' already exists.' when I try to add a linked server. And it does exist as a Remote Server because as I mentioned, the two servers are replicating data.

There has to be a way to add a linked server when two servers are already replicating. Or, there has to be a way to use the remote servers for data access.

Any suggestons?

Thanks,

You may have to use sp_addlinkedsrvlogin . This was new for SQL 2000
remote servers. There's also a kb article documenting this issue.

274098 PRB: Adding a Linked Server Causes Error 15028
http://support.microsoft.com/?id=274098


From Books Online:

Setting Up the Local Server
In SQL Server 2000, create remote server connections for remote server
logins created by Windows Authentication by:

Setting up a local login mapping on a local server that defines what login
and password are used by an instance of SQL Server when it makes an RPC
connection to a remote server.
For logins created by Windows Authentication, you must create a mapping to
a login name and password. This login name and password must match the
incoming login and password expected by the remote server.

Using the sp_addlinkedsrvlogin stored procedure to create local login
mappings.


Note For logins created by SQL Server Authentication, it is not necessary
to create any local login mappings for executing a stored procedure against
a remote server.

Security Note When possible, use Windows Authentication.

274098 PRB: Adding a Linked Server Causes Error 15028
http://support.microsoft.com/?id=274098


When configuring new subscribers for replication, SQL Server adds the
subscriber as a remote server and stores its information in the
master..sysservers system table. Subsequent attempts to add a linked server
using the same name as an existing subscriber may cause error 15028 to
occur:


Server: Msg 15028, Level 16, State 1, Line 0

The server 'SQL1' already exists.

The article also references the use of sp_addlinkedsrvlogin


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.