A .NET Framework error occurred during execution of user defined routine or aggregate

  • I am trying to execute a script in SQL Server 2005 against a database, getting below error. PLease advice

    Msg 6522, Level 16, State 1, Line 10

    A .NET Framework error occurred during execution of user defined routine or aggregate 'FN_Encrypt':

    System.Security.Cryptography.CryptographicException: Padding is invalid and cannot be removed.

    System.Security.Cryptography.CryptographicException:

    at System.Security.Cryptography.RijndaelManagedTransform.DecryptData(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode paddingMode, Boolean fLast)

    at System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)

    at System.Security.Cryptography.CryptoStream.FlushFinalBlock()

    at System.Security.Cryptography.CryptoStream.Dispose(Boolean disposing)

    at System.IO.Stream.Close()

    at System.IO.Stream.Dispose()

    at WD.Security.Cryptographer.Decrypt(Byte[] data, Byte[] key, Byte[] iv)

    at WD.Security.Cryptographer.CLREncrypt(Byte[] masterKey, Byte[] eskey, String plainText)

  • Hi Dude try this out.

    http://www.sqlcoffee.com/Troubleshooting015.htm

  • Hi

    Is your problem resolved, if yes can you please share the solution i am under same situation now

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply