Sql server msg 15466 an error occurred during decryption

Remove From My Forums. Answered by:. Archived Forums. SQL Server Security. Sign in to vote. Here is what I did to get the error: 1. What can I do to solve my issue? Thanking you in advance for your help. Regards, Barabello. Wednesday, July 11, AM. Dear Erlang, Erland. Marked as answer by amber zhang Tuesday, July 17, AM. Friday, July 13, PM. Thanks and regards. But reasonably, if you want to encrypt on one server and decrypt on another server, one of the following must apply: 1 Both servers must have the same service master key.

Hi, Can you find the key in the registry, it will be in this location. I ran the above on SQL If this does not answer your questions, please fill in steps that I have left out. Proposed as answer by amber zhang Thursday, July 12, AM. Wednesday, July 11, PM. Dear Erlang, Your code worked fine on both servers. Failed to retrieve data for this request.

ConnectionInfo —————————— An error occurred during decryption. An exception occurred while executing a Transact-SQL statement or batch. Please create a master key in the database or open the master key in the session before performing this operation. SQL Server service account was changed from services control manager or service master key was not backed up and restored when migrating SQL Server to another computer domain.

To manage a change of the service account, SQL Server stores a redundant copy of the service master key protected by the machine account that has the necessary permissions granted to the SQL Server service group. If the computer is rebuilt, the same domain user that was previously used by the service account can recover the service master key. When you are moving SQL Server to another computer, migrate the service master key by using backup and restore.

When the service master key is regenerated, SQL Server decrypts all the keys that have been encrypted with it, and then encrypts them with the new service master key. At the same time I would like to ask you to provide us with more information. If you have ever moved the master database from one machine to another, what kind of service account you are using i.

Thanks a lot,. SQL Server Engine. A ring buffer is an internal structure that captures information that can help us to understand a problem. Besides the ring buffer information, we will also appreciate more information on your particular scenario.

Have you changed the service account information? Is the machine part of a domain? Have you used the encryption features credentials, DBMK, etc. If you create the credential without a secret part, no encryption is needed and the statement will succeed. But without the secret part, your credential is unusable by SQL Agent. To figure out more about what is wrong with your setup, the following information is needed:.

I expect an error will occur. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 9.