Following a restart of a SQL Server 2012 SP3 instance caused by a reboot of the unresponsive host WINTEL server, I have a SQL Agent Log Shipping Copy job (which uses a proxy account to access the NAS file-share where the log backups reside) that is failing with this error:
Error authenticating proxy MyDomain\MyProxyAccount, system error: The user name or password is incorrect.
I have attempted to reapply the correct password to the proxy’s Credential and to recreate a new Credential and both fail with this error:
A key required by this operation appears to be corrupted. (Microsoft SQL Server, Error: 15507)
I’ve read an MSDN page that says:
SQL Server uses encryption keys to help secure data, credentials, and connection information that is stored in a server database. The Service Master Key is automatically generated the first time the SQL Server instance is started and is used to encrypt a linked server password, credentials, and the database master key.
I’m uncertain how to proceed. Do I have a problem with the Service Master Key? If so, can anyone suggest how to resolve this issue or direct me to further reading online?
Update: I've found entries in the SQL Server log (written when the instance was restarted following the host WINTEL server reboot) that further suggest that the issue lies with the Service Master Key:
Service Master Key could not be decrypted using one of its encryptions. An error occurred during Service Master Key initialization.
I'd still welcome any suggestions on how to fix this...