Creating a distributor with the sql server management studio and losing connection with the server

Posted in DBA, Microsoft Sql server, TSQL at 11:35 pm by

Scenario: Using the sql server management studio you are setting up a server to act as distributor. Then while you have clicked finished the connection is lost between your workstation and the server. Now the server thinks he’s a distributor but then again he’s not sure! You try to redo the previous action but that won’t work. What you need to do is tell the server to give up being a distributor.

use master

exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1


Now just restart the distribution creation wizard.

Leave a Comment