SQL Server Performance

Error while setting up publisher

Discussion in 'Performance Tuning for SQL Server Replication' started by motioneye, Jul 25, 2005.

  1. motioneye New Member

    Hi..
    One more error prompt by windows during setting up the Publisher.
    Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option 'publish' of database 'test' has been set to false.

    I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help

    sp_dropserver "servername", droplogins
    go
    sp_addserver 'servername', local
  2. dineshasanka Moderator

  3. satya Moderator

  4. motioneye New Member

    It works.. thanks...
  5. arka New Member

    quote:Originally posted by motioneye

    Hi..
    One more error prompt by windows during setting up the Publisher.
    Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option 'publish' of database 'test' has been set to false.

    I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help

    sp_dropserver "servername", droplogins
    go
    sp_addserver 'servername', local

  6. supnumb New Member

    quote:Originally posted by motioneye

    Hi..
    One more error prompt by windows during setting up the Publisher.
    Error 20028 The Distributor has not been installed correctly. Could not enable database for publishing. The replication option 'publish' of database 'test' has been set to false.

    I did exec sp_helpserver n checked for the ID=1 and run the sp above to register the server again but still giving me the same error..pls help

    sp_dropserver "servername", droplogins
    go
    sp_addserver 'servername', local

  7. MohammedU New Member

    Always check the server name on all servers involved in replication before replication configuration to avoid this kind of issues...
    SELECT @@SERVERNAME


    Mohammed U.
  8. satya Moderator

    Arka & Supnumb,
    What was your question?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page