none
SQL Server could not disable publishing and distribution on 'WIN-KPDO'. RRS feed

  • Question

  • Hi All,

    We have configured replication and wanted to remove it hence without any checklist we have deleted distribution database and wanted configure newly but couldn't find "configure distribution". Later we tried to disable publishing and distribution finally we received the below error. Please share your views on this and suggest on how to configure replication at this scenario. Thank You

    TITLE: Microsoft.SqlServer.ConnectionInfo
    ------------------------------

    SQL Server could not disable publishing and distribution on 'WIN-KPDO'.

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Database 'distribution' does not exist. Make sure that the name is entered correctly.
    Changed database context to 'master'. (Microsoft SQL Server, Error: 911)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3368&EvtSrc=MSSQLServer&EvtID=911&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Regards,

    Kalyan


    ----Learners Curiosity Never Ends----

    Monday, January 13, 2014 3:55 PM

All replies