Cleanup replication and setup again after name change on server

Unanswered Cleanup replication and setup again after name change on server

  • Tuesday, June 12, 2012 5:01 PM
     
     

    on our named Instance

    I stopped ms replication, then we renamed  the named server instance.   

    i tried my best to clean up replication an uninstall so I could set it back up again.

    but now i get the following errors

    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. (New Subscription Wizard)

    and

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

     i did the following

     select @@ Servername   it returned the name ok    PIB-SQLMSC01\whstest901

    select convert (char(25), serverproperty('servername')); PIB-SQLMSC01\whstest901

    sp_helpdistributor     was all null

    SP_ removedbreplication    runs

    sp_dropdistributor  say distrib is not installed

All Replies

  • Tuesday, June 12, 2012 6:31 PM
     
     
    I also though i could try to re install the replication feature  but its grayed out and i cannot re add it,  not sure how too get it deleted.

    Lou Mininni

  • Tuesday, June 12, 2012 7:53 PM
     
     
    So How do I get this back in order??????????????????????????????????????

    Lou Mininni