An error occurred during decryption

Question

Hi,

Under Security > Credential > we have a id say "ssisid" has setup. this was used to be the id to trigger SSIS package in sql agent.

Somehow after this Dev server crashed and we restored from copy of production DB. then we kept getting logon failure when running SSIS via sql agent.

When we tried to change password of this ssisid, we receieved below error:

    ------------------

     An error occurred during decryption. (Microsoft SQL Server,Error: 15466)

     Alter failed for Credential

if you know the cause, thanks in advance.

-Gene

Answer 1

I think you have restore the system databse along with user database from Production to Dev & your production server is having Service Master Key (SMK).

When you are moving SQL Server to another computer, migrate the service master key by using backup and restore.

Try to backup & restore the service master key from Production to DEV & try again.

Refer Links :

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/b0c49b64-70a0-453d-b686-5956c006af57/

http://technet.microsoft.com/en-us/library/ms187788.aspx

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 2

Thanks Rohit,

 If I ask our DBA "to backup & restore the service master key from Production to DEV ", will they understand?

Or there are any spscific steps need to be performed?

-Gene

Answer 3

Yup, DBA will surely understand what "to backup & restore the service master key from Production to DEV " means.

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!