August 11, 2010 at 5:35 pm
I have a snapshot replication between 2 servers using VPN. At Publisher, I am able to run the replication Manager and everything works. My boss-wants to view the Synchronization status at the subscriber-rather than at the publisher. When I click on view Synchronization status at the Subscriber, I get the awful message saying Failed to connect to server..A network-related or instance error occured while establishing connection to SQL server.
Question-Is this doable? viewing Synchronization Status at Subscriber? If it is no doable why is the option there? Any assistance is most appreciated.
August 12, 2010 at 1:55 pm
Check your firewall rules from Subscriber to Publisher. UDP port 1434 should be open to connect using SSMS and 1433 should also be open. Are these two servers on different domain?
-Roy
August 12, 2010 at 4:29 pm
Thanks for the response Roy. Yes-indeed both of these servers are on different domains. I also have another problem where I can ping from one server to the other-can connect using IP address-but can not connect using the server name. The host file has an entry for the server that I am trying to connect to. But somehow SQL just cannot see the other server. Thanks in advance for any help on this topic.
August 13, 2010 at 5:57 am
Do you have both named Pipes and TCP/IP enabled? Does the target server allow remote connections?
-Roy
August 13, 2010 at 6:01 am
Check if the DNS service is enabled for name resolution to happen.
Cheers
Cheer Satish 🙂
August 13, 2010 at 6:11 am
When there is a local host file, the DNS entry is not needed if I am not mistaken.
-Roy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply