Post reply

cannot disable publishing

  • March 25, 2004 at 7:44 am

    #84055

    Hi,

    I have a colleague who tried to set up replication. It did not work. I had a look on the sysservers. There was no entry with ID=0 for the local server. Instead the ID was 3. So we tried to drop this entry using sp_dropserver. It did not work, because of remote logins to this server. These remote logins were due to replication, so we tried to disable publishing.

    No we are in a trap. Each time we try to disable publishing and distributing, the system says, there is no replication (The item in the GUI is grey). But when we try to run the sp_dropserver it is said, we cannot do this because of existing replication settings.

    There is still a publication left, but it cannot be deleted as well.

    Are there any sps I can use to get rid of the corrupt replication settings or have I to try to delete records in the systemtables?

    The system is running SQL Server 2000 with SP3.

    thank you in advance

    Karsten

     

    These are the error messages when we try to delete the publication

    could not retrieve the subscriptions to publication 'Repl_Test'. Error 2812 could not find stored procedures

    could not delete publication 'Repl_Test'. Error 14071 could not find the Distributor or the dístribution database for the local server. The Distributor may not be installed, or the local server may not be configured as a publisher at the distributor.

     

    It is not, indeed, when I try to start disable publishing. But it is configured as publisher, when I try to run sp_dropserver.

  • March 26, 2004 at 12:54 pm

    #500730

    Did you change the server name while replication was setted up?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply