Decryptind CAPICOM Encrypted Data in TSQL or with CLR.

• bob.baast

  SSC Enthusiast

  Points: 117

  More actions

  February 16, 2010 at 12:55 pm

  #219214

  Hello everybody,

  Is there any function in MS SQL Server 2005 Enterprise (64 bit) to decrypt CAPICOM RC4 128 EncryptedData?

  I tried to use sp_OACreate 'CAPICOM.EncryptedData' it is not working because CAPICOM is 32 bit component and per this link it is not supported.

  Thank you.

• Paul White

  SSC Guru

  Points: 150467

  More actions

  February 21, 2010 at 10:29 am

  #1122525

  No.

  Since your question was posted in the CLR forum, I assume you are looking for a .NET-based solution to the problem.

  A quick Google search revealed this link:

  http://www.codeproject.com/KB/recipes/rc4csharp.aspx

  ...which may be of assistance.

  Paul

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi