April 13, 2010 at 10:02 am
HI all - i am trying to set up transactional replication between two servers on different subnets (i should say that i think they are different subnets, but my networking knowledge is pretty poor). Both servers are sql server 2005. Anyway, I've set up the publication without issue. When setting up the subscription, however, i am unable to connect to the publishing server by servername. i can make a basic connection in SSMS with the IP address. Does anyone know why the use of IP addresses is prohibited when setting up replication and if there is any way around this (in other words is there any way to use just the IP address?)
any help would be most appreciated.
Drew
April 14, 2010 at 6:52 am
You cannot use IPAddress for setting up subscriber. You could do something like creating a host file in your Publisher that will help resolve this issue. This is a temporary hack. You should have DNS entry for lookup to solve this issue.
-Roy
April 19, 2010 at 12:06 pm
That certainly seems to be the case. I just can't imagine why an IP address would not be acceptable. I mean, what's so great about a servername? who's with me???? anyway, problem is solved now with a host file. Thanks for the response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply