locked
An error occurred during decryption RRS feed

  • 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

    Tuesday, August 14, 2012 5:51 PM

Answers

All replies

  • 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!

    • Marked as answer by amber zhang Wednesday, August 22, 2012 2:20 AM
    Tuesday, August 14, 2012 7:00 PM
  • 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

    Sunday, August 19, 2012 3:58 PM
  • 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!

    • Marked as answer by amber zhang Wednesday, August 22, 2012 2:20 AM
    Tuesday, August 21, 2012 5:47 PM