Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

ADDITIONAL INFORMATION:

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.