Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: The Distributor has not been installed correctly

    I'm getting the following error in Sql Server 2000 'The Distributor has not been installed correctly',When I'm trying to remove/create a new Replication..Please Help

  2. #2
    Join Date
    May 2002
    Posts
    6
    I hope somebody can help. I've got the same problem.

    We ran the following script:
    Code:
    use [DESSP001]
    GO
    
    -- Dropping the merge publication
    exec sp_dropmergepublication @publication = DESSP001_Pub'
    GO
    
    -- Disabling the replication database
    use master
    GO
    
    exec sp_replicationdboption @dbname = N'DESSP001', @optname = N'merge
    publish', @value = N'false'
    GO
    
    use master
    GO
    
    exec sp_dropdistributor @no_checks = 1
    GO
    And got the following:

    Server: Msg 20026, Level 16, State 1, Procedure sp_dropmergepublication, Line 94
    The publication 'DESSP001_Pub' does not exist.
    Server: Msg 20029, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 55
    The Distributor has not been installed correctly. Could not disable database for publishing.
    Server: Msg 20029, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 55
    The Distributor has not been installed correctly. Could not disable database for publishing.



    I've checked serveral sources, no one seems to have a clue. The only thing that I found that even came close was a suggestion to open a call to MS Support Center.

    I'm a developer, not a DBA and I feel like the blind leading the blind.
    Any help would be appreciated.

  3. #3
    Join Date
    May 2002
    Posts
    25
    i once took a shot at doing that on my machine and i got the same errors. we had other mahcines that we followed the same steps and it worked. strange...

  4. #4
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Got it Fixed

    Do the Following:

    Use the following code:
    use master
    sp_configure 'allow update',1
    Reconfigure with Override

    Go to Master---Sysdatabases---Open---and go to the Category column for the Distribution database and make it 0(from 16).You are all set to Delete the Distribution DB.Hooohoo..

    use master
    sp_configure 'allow update',0
    Reconfigure with Override


    In order to Delete the Distributor(from the Remote Server) do the following:
    use master
    sp_configure 'allow update',1
    Reconfigure with Override

    Go to Master---Sysservers---Open---and delete the entries for all the servers(even the Local server).

    In my case the server id for my local was changed from 0 to 1(so I had to delete it).

    Now run the following code to add the Local server with 0 id:

    sp_addserver 'Local Servername','Local'

    Run select @@servername
    It will retrun Null and if you try to set the Replication at this point then you will get the following: (Null) cannot be configured as a Distributor..

    So Stop and Restart the Services on the Sql Server and again run:


    Select @@servername and this time it will return the Local server name and you are all set to run the Replication again..

    Yeah run it before you leave:
    use master
    sp_configure 'allow update',0
    Reconfigure with Override

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •