SQL Server Performance

Need help with 2005 Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by yz3, Oct 24, 2006.

  1. yz3 New Member

    I'm trying to replicate a db between 2 2k5 sql boxes. My first problem is that I cannot install Management Studio on my one sql box because it says it's already there, yet when you go to start-programs-sql..- all you see is config tools. I ran setup from CD2 several times chose books, online, etc.. and client tools and get that error.

    Secondly,
    I'm trying to create my subscriber sql box (the same one mentioned above) to pull replicate from my distributor but I keep getting an error saying:

    "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

    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, 'SQL2005'. (Replication.Utilities)"

    What does that mean?
  2. satya Moderator

    Run SELECT @@SERVERNAME and see the results.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. yz3 New Member

    I ran it and it came back saying SQL2005, now what?
  4. satya Moderator

    Has it returned correct servername?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. yz3 New Member

    No, the SQL Server name is called DB01MOC
  6. satya Moderator

    Then you need to perform SP_DROPSERVER and add back servername with SP_ADDSERVer, refer to books online for moreinformation.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page