SQL Server Performance Forum – Threads Archive
Replication from 2000 to 2005HI All, I am trying to set replication of a SQL Server 2000 DB to SQL Server 2005. The source DB located on SQL Server 2000. I have set all the distribution and publication on SQL Server 2000. The SQL Server 2000 instance not using the default port to connect, it is using the port 1193 and when I am trying to connect to this server in SQL 2005 it is asking for port number as well like ServerName, 1193. Then only I am able to connect to this server from 2005. But when I am trying to create the subscription from 2005 server and passing the name as ServerName, 1193 it is saying that it should be only ServerName and when I am giving only ServerName it is showing that no server exist. Can anyone help me on this urgent. Thanks, Shekhar "No passion in the world is equal to the passion to alter someone else’s draft."
It is showing me the below error message.
TITLE: Connect to Server
—————————— Cannot connect to ServerNameInstanceName. ——————————
ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click:http://go.microsoft.com/fwlink?Prod…rver&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ——————————
BUTTONS: OK "No passion in the world is equal to the passion to alter someone else’s draft."
Make sure the client alias has been defined properly.
Take help of KBAhttp://support.microsoft.com/kb/328306 that might give some solution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.