Re: Does replication setup make some entry in the Remote servers setti

Remote Servers and Linked Servers are all stored in the sysservers table in
the master database. Different flag values determine what an entry actually
represents. There is even a special entry for the local server name. If
you want or need to use a replication participating server as a linked
server, there is a special work-around to enable that functionality.

PRB: Adding a Linked Server Causes Error 15028
http://support.microsoft.com/kb/274098/en-us

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP





"Wingman" <Wingman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC17EBF5-D4FF-49C6-83A7-7E3E4F8D0FE0@xxxxxxxxxxxxxxxx
> If I create a transactional replication - Push method in SQL 2K standard
> with
> sp4, will replication create entries in the Remote Servers setting in EM?
> Currently I found three entries in the Remote Servers listing, server name
> for the publishing server name, server name for the subscriber server, and
> repl_distrbutor.
>
> If the replication does make these entries, I have no problem with the
> repl_distributor being there. But I have problem with the subscriber
> server
> name being there because I want to create a Linked Server with that same
> name
> but I can't since the name is already in use by the remote servers.
>
> Please let me know which one or all of the above names are legit if indeed
> repliation put them in there to begin with.
>
> Say if the above entries need to be there, how I should move them to the
> Linked Servers setting because the remote servers feature is for backward
> compatible reason and linked servers is more dynamic and is the one to
> replace it.
>
> Thanks in advance.
>
> Wingman


.

Relevant Pages

  • RE: Memory issues with Linked Servers
    ... That worked for the reading part of the linked server ... we are able to fix the linked servers. ... > gets memory for its OLE DB providers) to see if it is indeed getting ... > MemToLeave space being exhausted? ...
    (microsoft.public.sqlserver.server)
  • Re: Wierd Primary Key issue
    ... the production server and then I removed the foreign key restraints. ... I have written queries to access data on linked servers using 4-part names ... The columnthat make up the primary key: ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL2005 Linked server authentication problem
    ... out this double-hop kerberos issue with linked servers in SQL2005 is an ... The problem occurs when I tried to connect from a client PC, to a SQL ... from a different server e.g. ...
    (microsoft.public.sqlserver.security)
  • Re: Job Failure
    ... Tibor Karaszi, SQL Server MVP ... > set up to use a valid account on the linked servers. ... >>You will get problems is the job owner isn't sysadmin, ...
    (microsoft.public.sqlserver.server)
  • Re: whats the difference between Linked servers and Remote servers under EM/security?
    ... Remote servers are for backwards compatibility. ... Both remote servers and linked servers add a row to ... The server name needs to be unique. ...
    (microsoft.public.sqlserver.server)