An error occurred during service master key initialization (sql error log)
0
votes
0
answers
2232
views
I have migrated sql server 2017 to new hardware. The sql error log shows following error log whenever the sql server service is restarted.
An error occurred during service master key initialization
I recently restored the master, msdb databases from older hardware to new hardware. Linked servers don't work for example if I try to create a linked server it gives following error: An error occurred during service master key decryption
. Same error when creating credential.
I understand this is something related to the SMK (service master key).
Doesn't the SMK already exist since I have restored the master database (assuming the SMK is held in the master db)?
Why am I getting these errors? Why can I not create/access linked sever and credentials?
Asked by variable
(3590 rep)
May 11, 2022, 08:37 PM
Last activity: Aug 15, 2022, 07:40 AM
Last activity: Aug 15, 2022, 07:40 AM