none
SQL Server 2017. Implementing Replication on a Failover Cluster failed RRS feed

  • Question

  • Hello 

    I am trying to implement a replication on a failover cluster but I am getting the following error when I tried to create the distribution database:

    "Could not load file or assembly 'Microsoft.SqlServer.Replication.dll' or one of its dependencies. The specified module could not be found. (Microsoft.SqlServer.Rmo)"

    Also I would like to hear from someone that had implementing a replication in a failover cluster in SQL Server 2017 or higher

    Thanks in advance

    

    Wednesday, September 25, 2019 1:57 PM

Answers

  • I've configured it and it works successfully. I am guessing you did not install replication components successfully on both (all) nodes?
    • Marked as answer by Rey1962 Wednesday, September 25, 2019 4:01 PM
    Wednesday, September 25, 2019 2:50 PM
    Moderator

All replies

  • I've configured it and it works successfully. I am guessing you did not install replication components successfully on both (all) nodes?
    • Marked as answer by Rey1962 Wednesday, September 25, 2019 4:01 PM
    Wednesday, September 25, 2019 2:50 PM
    Moderator
  • Thank you so much for your reply.

    I will check the SQL Server installation to see what is missing.

    Thanks Again

    Wednesday, September 25, 2019 4:01 PM
  • Hi, i am having the same issue as mentioned before and i tried a reinstall of SQL Server replication feature but with no luck.

    Do you have any idea what can i try next?

    Thanks!

    Tuesday, February 25, 2020 12:13 PM
  • Just so i am clear:

    I installed SQL Server Replication feature with success and then when i want to configure distributor i get:

    Could not load file or assembly 'Microsoft.SqlServer.Replication.dll' or one of its dependencies. The specified module could not be found. (Microsoft.SqlServer.Rmo)
     
    ------------------------------
    Program Location:
     

       at Microsoft.SqlServer.Replication.ConnectionSecurityContext.get_WindowsAuthentication()
       at Microsoft.SqlServer.Management.UI.Publisher.get_DistributionPublisher()
       at Microsoft.SqlServer.Management.UI.ConfigureDistributionWizard.OnInitializeProgressPage()
       at Microsoft.SqlServer.Management.UI.WizardForm.Finish()
       at Microsoft.SqlServer.Management.UI.WizardForm.Finish_Click(Object sender, EventArgs e)

    Tuesday, February 25, 2020 12:20 PM