[error messages as follows: 15466, level 16, state 2, process
Sp_addlinkedsrvlogin, line 91
Error during the service master key decryption,]
Start a local SQL configuration manager hot standby database, remote connection in system database - tempdb for execution
ALTER the SERVICE MASTER KEY FORCE REGENERATE
An error
To decrypt the current master key can't, because the specified FORCE option, so ignore this error and the
Directly through the remote desktop connection into the double machine hot standby database server (currently running database server)
The system database in the SQL configuration manager - tempdb for execution
ALTER the SERVICE MASTER KEY FORCE REGENERATE
Success
Testing stored procedure also normal execution, but the problem is the double machine hot standby every time to switch from the database will appear as above problem, now didn't find a good solution, strives for the great god of action!
CodePudding user response:
Your problem solved? I also encountered such a problem, at present is mainly stored procedures to perform database has a agent operation of external links server of some of the operation, the original poster to how to solve? !!!!!