Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

Dbamp issue - unable to get effective support : Master Key issue

we have installed dbamp on a SQL 2012 server that had the service account changed some while back using sql config manager.
all aspects of the server are absolutely fine including linked servers to other cloud databases.
dbamp however refuses to replicate tables at random citing a master key error
support is unable to provide us with effective suggestions to resolve apart from force regenerating the key which is not an option on a production server.
just wondering if any one else has encountered a similar issue?
thanks
1 person has
this problem
+1
Reply
  • I believe we have given effective support.

    The bottom line is that your SQL Server instance is throwing an error saying that your Master Key cannot be decrypted. I understand that this only occurs with DBAmp but that does not change the fact that it is the SQL Server process that cannot decrypt his own storage of userid and password. The DBAmp process is not involved in the code at that moment this error occurs.

    We have suggested the following to you:

    1. Move the installation of DBAmp to another server at least temporary to confirm that this is indeed an issue with that SQL Server.

    2. Regenerate the Master Key with the FORCE option. I understand that this is a draconian step for a production box when you are just trialling DBAmp and therefore our recommendation is option 1.

    We have identified the issue for you and provided 2 alternative approaches to solving the problem.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    Yes we have no other option to do as you suggest, however since EVERY OTHER linked server install on the SQL server is working fine, this is definitely a problem with dbamp being unable to decrypt a legitimately installed master key.

    This is in addition to the fact that the error is intermittent - wherein the replication, and (I therefore expect) the decryption is working fine, but then fails again. I am unable to understand how this could occur unless it is an issue with the decryption logic hosted in dbamp? I note your response above does not qualify, or explain this.

    We have even tested this with a different SQL 2012 server where the service account has been changed and the exact same issue occurs (even with the FORCE option). we have tested this also with a third party restore application that explicitly needs to decrypt master keys as a part of restoring the database.

    In other words in our humble opinion the problem definitely lies with dbamp in the scenario where service accounts are changed. we can address the issue possibly by using a fresh or different install of sql but this is still a (big) workaround..

    With all due respect, suggesting workarounds plus saying '..there is nothing dbamp can do in this situation..' as per your earlier email, does not qualify as effective support or elevate dbamp standing as a vendor in our eyes.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • To clarify, you have installed DBAmp on a second SQL server instance?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned