SQL Server Performance

Replication from 2000 to 2005

Discussion in 'SQL Server 2005 Replication' started by shekhar157, Nov 7, 2006.

  1. shekhar157 New Member

    HI 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."

  2. shekhar157 New Member

    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."

  3. satya Moderator

Share This Page