Post reply

Linked server to Oracle error during decryption

  • January 15, 2010 at 11:03 am

    #219377

    Hi,

    I've got an issue which i can't get solved temporarily.

    We have a 64-bits sql server 2005 clustered environment with 4 nodes. We've also got a couple of named instances running on those servers. Each named instance has got his own ip-adres. When using linked server and failing over the instance we get the "Error during decryption" message. I got the following from the internet: ( But when using this, the problem is sort of a kind solved ) But i am looking for a temporarily solution preventing us from every time running below solution in a production environment where you are not sure when a failover takes place in the evening and we are not there to solve it and the linked server fails. That is really not the way you want it to work. So if anyone has a solution for my problem please help. Kind regards, Bryan

    I don't know if below information is correct. I tried them all maybe not in the right order.

    ALTER SERVICE MASTER KEY FORCE REGENERATE

    create master key encryption by password = 'password'

    USE [master];

    GO

    OPEN MASTER KEY

    DECRYPTION BY PASSWORD = 'password';

    ALTER MASTER KEY

    DROP ENCRYPTION BY SERVICE MASTER KEY;

    ALTER MASTER KEY

    ADD ENCRYPTION BY SERVICE MASTER KEY;

    CLOSE MASTER KEY;

    GO

    OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'

    alter master key regenerate with encryption by password = 'password

  • February 22, 2010 at 3:55 am

    #1122816

    Hi,

    Solved the problem by using a force regenerate of the master key in a procedure and marked the procedure in sql server to execute at startup.

    bryan

  • February 22, 2010 at 12:44 pm

    #1123206

    Thank you for the follow up.

    Sooner or later somebody will benefit from your post.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply