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.
| Author |
Topic |
|
BradFMJ
Starting Member
3 Posts |
 Posted - 2007-09-26 : 14:17:41
|
| I have a sql server 2005 that is acting as the Publisher/Distributer. I want to set up a push subscription to a remote sql server 2005 that is on a different network. The problem I am encountering is that SQL server says I am required to use the computer name of the Subscriber, not an IP address.I thought maybe I could add the remote server as a linked server and then reference it by the linked name but that doesnt seem to be an option.Is there anyway to accomplish this?Thanks! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-26 : 14:25:49
|
| You can use IP of the subscriber. I have a replication currently running, using an IP for the subscriber.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
BradFMJ
Starting Member
3 Posts |
Posted - 2007-09-26 : 15:09:01
|
| I am getting the error message: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, 'ActualServerNameIsHere'. (Replication.Utilities)This results from trying to connect to an sql server 2005 instance using an IP address and a sql server login. The resulting error message has the actual name of the server I am trying to connect to. However I am so far unable to use that.http://www.fiftydkp.com/subscriber.jpg |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-26 : 15:17:37
|
Try adding the IP Address to the HOSTS file and use the hostname.
Future guru in the making. |
|
|
|
BradFMJ
Starting Member
3 Posts |
Posted - 2007-09-26 : 15:25:56
|
| Thanks! Adding the IP as an entry to the HOSTS file allowed me to use the computer name instead of an IP address =D |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-26 : 16:21:06
|
Good to hear that it worked. A bit of advice, make sure you document this setup clearly because if there is ever an IP readdress that takes place in the environment it will come back to bite you!
Future guru in the making. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-26 : 16:27:06
|
quote:
Originally posted by Zoroaster
Good to hear that it worked. A bit of advice, make sure you document this setup clearly because if there is ever an IP readdress that takes place in the environment it will come back to bite you!
Future guru in the making.
which is exactly what happened at my palce a couple of weekends back and I had to re-setup the replication because the Servername was not correctly mapped to the IP  Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Replication to remote server