Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When trying to configure a publication I get the below error.

SQL Server could not configure 'MyServer' as a Distributor.


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The server 'MyServer' is already defined as a Distributor. To reconfigure the server as a Distributor, you must first uninstall the exisiting Distributor. Use the stored procedure sp_dropdistributor, or use the Disable Publishing and Distribution Wizard.
Changed database context to 'master'. (Microsoft SQL Server, Error: 14099)

How can I tell if this is configured to be a distbitor...Becuase when I go back a few steps in the wizard tot the "Distbutor" step I tried use the option that says

"Use the following server sas the Distributor (Note: the server you select must arelady be configured as a a distbutor. )"

but when I select this option and try to add the MyServer I get the erorr:

'MyServer' is not configured as a Distributor. Select a server that is configured as a Distributor.

The server is not currently a distrutor (that I know of) and the wizard seems to think it is and it isn't. Am I crazy???

EDIT: Mirroing is setup on the database and server that I am trying to configure. Does that make a difference?

share|improve this question
up vote 0 down vote accepted

had to use sp_dropdistributor, but I was able to add a distributor of my choosing after that.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.