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\whstest901select convert (char(25), serverproperty('servername')); PIB-SQLMSC01\whstest901
sp_helpdistributor was all nullSP_ removedbreplication runs
sp_dropdistributor say distrib is not installed
All Replies
-
Tuesday, June 12, 2012 6:31 PMI 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 PMSo How do I get this back in order??????????????????????????????????????
Lou Mininni

