none
The Distributer Has not been Installed Correctly - Error 20036 SQL 2014 RRS feed

  • Question

  • Dear All,

    Could anyone help me with create new publication. currently we plan to activate of database server to DR site. we have 2 sql alwaysOn environment

    1.Environment #1 with SQL alwaysOn

      -DC site (DC-DB01,DC-DB02)--->Primary &Secondary node

      -DR Site (DR-DB01)--->Secondary node

    2.Environment #2 with SQL AlwaysOn

     -DC Site (DC-DB03, DC-DB04)--->Primary &Secondary node

     -DR Site (DR-DB02)--->Secondary node

    At DC site on environment #1 (DC-DB01) we have created publication. And we have created one subscription on environment #2 (DC-DB03). we have failover database to DR site and recreate new publication on environment #1 and subscription on environment #2 at DR site. but we are meet one issue while we creating publication at dr  site "SQL Server could not create publication.....The Distributor has not been installed correctly (Microsoft SQL server, Error. 20036)"

    here's my step above

    1.Stop Service replication at DC-DB01
    2.Remove subcription at DC-DB03
    3.Remove Publication at DC-DB01
    4.Failover all Database environment #1 to DR-DB01 (DR)

    5.Failover all Database environment #2 to DR-DB02 (DR)

    6.Create publication on DR-DB01 at DR site

    7.Create subscriber on DR-DB02 at DR site 

    Thanks !


    • Edited by Peang Suy Tuesday, October 8, 2019 1:23 AM
    Saturday, October 5, 2019 1:29 PM

All replies

  • Hi,

    This is due to the first step failing. This page seems similar issue? Or start again and see if that works?

    Thanks,
    Matt

    Saturday, October 5, 2019 9:32 PM
  • Hello Bradley, The publication already removed from replication and also subscribtion. And we don’t see the publication and subscribtion on server anymore. We have tried two or 3 times ready but still can’t create publication at DR sites . It’s from publication not complete deleted ? Or our steps is wrong process?
    Sunday, October 6, 2019 2:08 AM
  • Hi Peang Suy,

     

    >>we have failover database to DR site and recreate new publication on environment #1 and subscription on environment #2 at DR site. but we are meet one issue while we creating publication at dr  site "SQL Server could not create publication.....The Distributor has not been installed correctly (Microsoft SQL server, Error. 20036)"

     

    Did you configure distributor on  DR site at environment #1? Use EXEC sp_get_distributor  to check it.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, October 7, 2019 9:13 AM
  • Hello Dedmon,  at DR i don't see distributor install.

    Monday, October 7, 2019 2:07 PM
  • You should be using a remote distributor.

    Did you try this:

    sp_adddistributor and pass the remote distributor name and its password?

    Monday, October 7, 2019 5:45 PM
    Moderator
  • Hi Peang Suy,

     

    As Hilary said, do you configure remote distributor?

     

    exec sys.sp_adddistributor 

        @distributor = 'MyDistributor', 

        @password = 'its password'

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Tuesday, October 8, 2019 3:25 AM
  • Hello Hilary, we are successfully completed configure for remote distributor and now we can created publication at dr site. but i don't see service running on My publishers->DR-DB01& DC-DB01->Publcations -> Status is no service are running and also stored procedures not update from Environment #1 (DR-DB01) to environment #2 (DR-DB02) at DR site.

    Did you know what issue ? 

    Noted: currently,

    - Environment #1 (DR-DB01) is primary database

    - environment #2 (DR-DB02) is primary database

    Best Regards,

    Peang Suy.



    • Edited by Peang Suy Tuesday, October 8, 2019 5:05 AM
    Tuesday, October 8, 2019 4:23 AM
  • yes Dedmon, we can create publication now. but now we have other issue with table not update in stored procedures. do you have any idea on this issue? as i replied back to you and  Hilary for help.

    Thanks.


    • Edited by Peang Suy Tuesday, October 8, 2019 4:29 AM
    Tuesday, October 8, 2019 4:26 AM
  • Hello Hilary, Now our issued has resolved by follow your instructions.

    Thanks you so much.

     
    Thursday, October 10, 2019 4:46 AM
  • Hello Dedmon, Now our issued has resolved by follow your instructions.

    Thanks you so much.

    Thursday, October 10, 2019 4:46 AM
  • Hi Peang Suy,

     

    I am glad to know that your problem has been solved. In order to close this thread, please  mark useful replies as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, October 10, 2019 5:13 AM