Hello;

I’ve run across another issue with replication, I am pushing a
publication out to a remote server. Looking through the history of
the distribution agent, I see the scripts are applied, but once they
are finished, the agent fails with the following error message:

Could not find server ’10.2.1.12’ in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.

the error details are:

Could not find server ’10.2.1.12’ in sysservers. Execute sp_addlinked
server to add the server to sysservers.
(Source: [my subscribing database] (data source); Error number 7202)

(10.2.1.12 is the internal ip of another sql server that is linked to
this instance, it’s setup in linked servers as ’10.2.1.12’)

I find this perplexing, as nowhere in the setup process of the
replication, or the subscriber setup, did I reference this linked
server, the subscriber is setup as a remote server.

I cannot figure out why replication would reference the linked server
while pushing out to a remote server. Any thoughts would be
appreciated.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Replication-SQL-referencing-unwanted-Linked-Server-ftopict246297.html

[quoted text, click to view]

Classic case of think before you post...

Linked server was referenced by the database I am trying to replicate,
so the subscriber needed the linked server setup as well.