Questions

how to configure SQL 2005 replication

Tags:
+
0 Votes
Locked

how to configure SQL 2005 replication

jazzygodfrey
hi, i am trying to configure replication on my local machine where sql server is, and it gives me the following error when
i right click replication--configure distribution, what could be the problem?;

SQL Server is unable to connect to server 'IS-GODFREY'. (Configure Distribution Wizard)


SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'PSPF-PC'. (Replication.Utilities)
  • +
    0 Votes
    jazzygodfrey

    I found out that somehow my server name was renamed, it was not equal to the instance name when i ran sp_@@SERVERNAME
    OR'
    SELECT @@SERVERNAME As [@@SERVERNAME],
    CAST(SERVERPROPERTY('MACHINENAME') AS VARCHAR(128)) + COALESCE('' +
    CAST(SERVERPROPERTY('INSTANCENAME') AS VARCHAR(128)), '') As RealInstanceName


    I ran the query
    exec sp_dropserver [oldservername]
    GO
    exec sp_addserver [newservername], 'local'
    GO

    and then Restarted the sql server service
    and boom!

    I can now configure replication!
    solved my own puzzle!

  • +
    0 Votes
    jazzygodfrey

    I found out that somehow my server name was renamed, it was not equal to the instance name when i ran sp_@@SERVERNAME
    OR'
    SELECT @@SERVERNAME As [@@SERVERNAME],
    CAST(SERVERPROPERTY('MACHINENAME') AS VARCHAR(128)) + COALESCE('' +
    CAST(SERVERPROPERTY('INSTANCENAME') AS VARCHAR(128)), '') As RealInstanceName


    I ran the query
    exec sp_dropserver [oldservername]
    GO
    exec sp_addserver [newservername], 'local'
    GO

    and then Restarted the sql server service
    and boom!

    I can now configure replication!
    solved my own puzzle!