dbTalk Databases Forums  

Error with IP ? - The subscription to publication 'blebleble' is invalid.

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Error with IP ? - The subscription to publication 'blebleble' is invalid. in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wojtek Z
 
Posts: n/a

Default Error with IP ? - The subscription to publication 'blebleble' is invalid. - 11-19-2004 , 01:25 AM






When I try to do create a merge replication A -> B i get this error :

"The subscription to publication 'KrowaPub2' is invalid.
(Source: Merge Replication Provider (Agent); Error number: -2147201019)
----------------------------------------------------------------------------
-------------
The remote server is not defined as a subscription server.
(Source: 10.1.0.3\MSSQL3 (Data source); Error number: 14010)
----------------------------------------------------------------------------
-------------"

Server B is added to A subscribers list as a AddressIP\InstanceName (
10.1.0.3\mssql3).

When I've added B to A subscribers list as a HostName\InstanceName (
Bydgoszcz\mssql3 ) and created second push subscribtion to this new B it was
ok

Cant I use IP address ? What if servers are in diffrent sub-networks? I cant
connect to server by Host Name and when I try with IP i get this error :/

Best Regards
Wojciech Znaniecki



Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default Error with IP ? - The subscription to publication 'blebleble' is invalid. - 11-19-2004 , 03:08 AM






Try creating an alias to the IP address.
(see http://support.microsoft.com/?id=321822)
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.