February 17, 2011 at 9:24 am
I am trying to set up replication from a SQL2005 database in one Veritas cluster to a SQL 2000 database in another Veritas Cluster. This is on the same network.
I keep getting the error SQL Server Replication requires the actual server name to make a connection to the server error.
I have set up an alias on the Publisher in 2005. (I have tried both named pipes and TCP/IP aliases.) The subscriber has the correct name for the virtual cluster server name when you select @@servername.
I have tried to connect to the physical hostname/ instance name as well. No luck either. Same issue.
Does any one have any idea what I can do next to solve this issue?
Named pipes are enabled on both servers.
The replication is transactional one way with a separate distribution database on the 2005 cluster. This is also a virtual cluster server name. There seemed to be no problem setting up the publisher.
February 17, 2011 at 9:39 am
john.kaye (2/17/2011)
I am trying to set up replication from a SQL2005 database in one Veritas cluster to a SQL 2000 database in another Veritas Cluster. This is on the same network.I keep getting the error SQL Server Replication requires the actual server name to make a connection to the server error.
I have set up an alias on the Publisher in 2005. (I have tried both named pipes and TCP/IP aliases.) The subscriber has the correct name for the virtual cluster server name when you select @@servername.
I have tried to connect to the physical hostname/ instance name as well. No luck either. Same issue.
Does any one have any idea what I can do next to solve this issue?
Named pipes are enabled on both servers.
The replication is transactional one way with a separate distribution database on the 2005 cluster. This is also a virtual cluster server name. There seemed to be no problem setting up the publisher.
Have you read through this post yet? If not let me know what you find. It seems you have done some of what is being described already....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply