Question

  • Creator
    Topic
  • #2213118

    how to configure SQL 2005 replication

    Locked

    by 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)

All Answers

  • Author
    Replies
    • #2826200

      Clarifications

      by jazzygodfrey ·

      In reply to how to configure SQL 2005 replication

      Clarifications

    • #2826184

      how to configure SQL 2005 replication-SOLVED

      by jazzygodfrey ·

      In reply to how to configure SQL 2005 replication

      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!

Viewing 1 reply thread