January 15, 2010 at 11:03 am
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
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
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