all groups > sql server replication > may 2006 >
You're in the

sql server replication

group:

The distributor is not installed correctly could not disable datab


The distributor is not installed correctly could not disable datab Edward
5/12/2006 2:39:01 PM
sql server replication:
Hi
I have major problems reconfiguring my MSSQL 20005 server regarding
replication.

We had to reinstall Windows and MSSQL2005 because of some diskproblems.
After reinstalling we attached our database back which were copied to another
server before. Some database had merge replication set up. Worked perfectly.

When the server was up and running it was time to configure the replications
we had. When I try to add a publication I got: 'Could not find the
Distributor database for the local server. The Distributor may not be
installed, or the local server may not be configured as a publisher.'

After this I thought something is wrong and I wanted to start all over again
bij using the option: 'Disable publishing and distribution' now I got: 'The
distributor is not installed correctly could not disable database for
publishing'

I tried a lot and get a bit frustrated because It used to work and now it
looks a bit like a mess.

How can clean every replication thing up and start from scratch?

If you have a solution that works I like to hear from you!

Ciao
Ed






RE: The distributor is not installed correctly could not disable datab Edward
5/14/2006 11:18:01 AM
the answer:

after re-attaching a replicated database to a different server remove all
replication stuff from that database with:

USE master
EXEC sp_removedbreplication N'databaseName'


Ciao




[quoted text, click to view]
Re: The distributor is not installed correctly could not disable datab john.gagnon NO[at]SPAM gmail.com
5/15/2006 10:29:01 AM
After you ran 'Disable publishing and distribution'

Did you successfully run:

"Configure Distribution..."
AddThis Social Bookmark Button