I have Microsoft SQL Server 2005 - 9.00.4053.00 (X64) and I want to configurate Replications. I have received an error which is similar to this here: http://dbfriend.blogspot.com/2010/01/error-occurred-during-decryption-when.html and I want to solve this problem
with command ALTER SERVICE MASTER KEY REGENERATE FORCE.
I would like to ask you what I can lose with FORCE option? I have read it should be linked server login passwords and credential secrets.
Will this command ALTER SERVICE MASTER KEY REGENERATE FORCE affect the connections from linked servers which point to this machine from another SQL Servers?
If I run exec sp_linkedservers, I receive 1 row where SRV_NAME is the same as @@servername. There are no other linked servers.
There is a structure of data I have found. Please tell me if there is something which could be lost after the command ALTER SERVICE MASTER KEY REGENERATE FORCE.
I have a few user databases but no data are returned when I run this command on them:
EXEC sp_MSForEachDB '
select * from sys.master_key_passwords ;
select * from sys.asymmetric_keys ;
select * from sys.crypt_properties ;
select * from sys.certificates ;
select * from sys.key_encryptions ;
select * from sys.credentials ;
select * from sys.symmetr
View Complete Post