Wednesday, March 7, 2012

Could not find server 'x.x.x.x' in sysservers

I am trying to set up transactional replication between two SQL Server 2000
machines and when the synchronization starts (I'm pushing from the publisher
to the subscriber), I get the following error:
Could not find server 'x.x.x.x' in sysservers. Execute sp_addlinkedserver to
add the server to sysservers.
(Source: OLISSQLSERVER1 (Data source); Error number: 7202)
Any suggestions? Thanks in advance!
Use client network utility to mask the ip address with a host name.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tayo" <Tayo@.discussions.microsoft.com> wrote in message
news:AE594037-A5A0-4FB7-B237-76BA39F53BFB@.microsoft.com...
>I am trying to set up transactional replication between two SQL Server 2000
> machines and when the synchronization starts (I'm pushing from the
> publisher
> to the subscriber), I get the following error:
> Could not find server 'x.x.x.x' in sysservers. Execute sp_addlinkedserver
> to
> add the server to sysservers.
> (Source: OLISSQLSERVER1 (Data source); Error number: 7202)
> Any suggestions? Thanks in advance!
|||Could you explain to me where and how to do this? I did some looking online
but wasn't sure what to do. Thanks for your help!
"Hilary Cotter" wrote:

> Use client network utility to mask the ip address with a host name.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Tayo" <Tayo@.discussions.microsoft.com> wrote in message
> news:AE594037-A5A0-4FB7-B237-76BA39F53BFB@.microsoft.com...
>
>

No comments:

Post a Comment