Event 15466 Error occured during decryption | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Event 15466 Error occured during decryption

Hi all,
Have moved the system databases to a new location.
Starte SQL 2005 in console mode and restored all sys db’s (master, model, msdb, mssqlsystemresource).
All works like a charm except on startup I’m getting the obove event.
If I move sql service account into local admin group the obove event disapers.
It seems that I missed out some granting in directory tree or registry?? Has anyone an idea?
TIA
acki
It is a generic error message but after the move have you restore the Service master key or used any options while restoring? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
satya,
Have not restored the SMK or used any options during restore.
You must restore the SMK from the backup using FORCE option, this option will be necessary to bypass the decryption of the SMK – because in this case it cannot be performed.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>