Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Can not add subscriber at remote server

Author  Topic 

Mohamed_Atef
Starting Member

1 Post

Posted - 2012-06-14 : 23:41:57
I have two servers in two different sites not in the same LAN ,I create publishing successfully ,but when I need to add subscription for this published data at remote server ,give me error .
I’m using SQL server enterprise edition ,disabled firewall ,configured SQL to have remote access using TCP/IP and UDP ,but still has an error.

TITLE: New Subscription Wizard
------------------------------

Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'WIN-CE7MFR4BV7O'. (Replication.Utilities)

------------------------------
BUTTONS:

OK


Mohamed Atef

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-06-15 : 00:20:27
You'll need to run setup again to add the replication components.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -