Unable to create subscriber

Question

Dear Friends,

I have two different sql servers one two different domains connected by internet. Iam working on Doman-A. Both sql server's are 2005

Domain Name  System Name         Sql Instance Name             Port No

Domain-A       SysA(IP:202.187.65.124)     SqlA                              1215

Domain-B       SysB(IP:102.45.68.125)       SqlB                               1465

Intially I was unable to connect from SysA to SysB through sql management studio. But after giving the connection string as 102.45.68.125\SqlB,1465 I was able to connect. Now my main problem is with the replication only. I had configured Publisher and Distrbutor on SysA. I want the subscriber to be SysB. But when I try to configure the subscription in the New Subscription Wizard from SSMS installed on SysA and try to Configure the subscription I get the following error message:

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

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, 'SysB\SqlB'. (Replication.Utilities)

Plz help me guys.

Thanking you

Chandra Mohan N

Answer 1

Hi,

there was a thread by  Hilary Cotter SQL 2005 Replication between 2 non trusted domains

Answer 2

I too have this issue.

 

My local server 'nld_server' is running 2003 server and SQL 2005 (9.0.3042). The remote 'remote1'/'remote.mydomain.com' server is running Winsows 2003 and SQL 2000 (8.0.760) - both fully up to date.

 

 

When attempting to connect to the server to create a login - I receive the following error report:

 

TITLE: Connect to Server
------------------------------

Cannot connect to maggie.netlynkdirect.com.

------------------------------
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, 'REMOTE1'. (Replication.Utilities)

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

OK
------------------------------

It is curious that the servers name is picked up.

 

It is notable the by clicking options and the connection properties tab, I am able to browse the server in the connect to database drop down list and see the databases - because of this I am guessign that this is a slight issue with a simple workaround?

 

 

Answer 3

 

 

I took the following steps to resovle this

1 - On the remote server, Ensure I am referencing the correct host name

SQL

Select @@servername

 

2 - On local server, create an alias to the remote using the name from the above

3 - On local server, Edit the hosts file to resolve the remoter host name to the remote ip

4 - Create the subscriber

 

 

Answer 4

I AM also getting some thing same kind of problem, but here one small change in my situation i am trying to create publisher on Server B Which is snap of Server A, how could i can configure this publication.

ERROR.

TITLE: Publisher Properties

------------------------------

An error occurred connecting to Publisher 'SERVER B'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.PubshrPropertiesErrorSR&EvtID=CantConnectToPublisher&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, 'SERVER A'. (Replication.Utilities)

------------------------------

BUTTONS:

OK

PLZ Respond .

Answer 5

Hi would you be so kind to provide more detail about how you fixed it?

I am confused about the user accounts I need to create on both servers.

your help will be highly appreciated.

Answer 6

Gavin Lilley  posted the solution... read it care fully...

I copied the same... and explaining more...

 

1 - On the remote server (Subscriber server) run the following sql statement

SELECT CONVERT(char(20), SERVERPROPERTY('servername'));
and take the out put which your Servername if it is default instance, servername\instancename if it is named instance and use the

ouput while configuring alias in step2..

 

2 - On local server (Publication server) , create an alias to the remote using the name from the above

You can create the Alias using "SQL SERVER Configuration Manger"....

Start/All programs/sql server 2005/SQL SERVER Configuration Manger/SQL Server Native Client Configuration/Aliases

Check BOL how to configure Alias

http://msdn2.microsoft.com/en-us/library/ms181035.aspx

 

3 - On local server(Publication server), Edit the hosts file to resolve the remoter host name to the remote ip

Host file location is C:\WINDOWS\system32\drivers\etc\

 

4 - Create the subscriber

 

 

Answer 7

 

 

I took the following steps to resovle this

1 - On the remote server, Ensure I am referencing the correct host name

2 - On local server, create an alias to the remote using the name from the above

3 - On local server, Edit the hosts file to resolve the remoter host name to the remote ip

4 - Create the subscriber

 

 

SQL

Select @@servername

 

I find that running "Select @@servername" and "SELECT CONVERT(char(20), SERVERPROPERTY('servername'));" may showing different result. Making sure their correctness will be the root of problem.

use the following cmd to change the @@servername, if necessary.

EXEC sp_dropserver '{current server name}'
EXEC sp_addserver '{new server name}', 'local'

*You have to restart the sql server to let the change effective

Hope the above help you out the problem.

---

Cliff