How to use encrypt/decrypt in SQL Server 2005

• Santhoshkumar KB

  SSCertifiable

  Points: 5066

  More actions

  September 15, 2009 at 2:44 am

  #215252

  We use OnBase at our work place and it was upgraded to a higher version,

  Prev Version of OnBase: v6.2

  Current upgraded version: v9.0

  Following the OnBase 9.0 upgrade and an associated .NET framework upgrade,

  two of the VB.NET applications lost the ability to decrypt (InvCipher method)

  account number and passwords from the INI file.

  Solution for this might be using hard coded values in INI file, but keeping security

  in mind another way is to store those account number and passwords in SQL

  Server 2005 using its encrypt/decrypt facilities.

  We are new to this encrypt/decrypt facility and need some guidance to use this.

  1. how to encrypt ActNo and Pwd in sql server 2005

  2. how to decrypt/validate it from VB.NET application

  Thanks,

  KB

  Thanks,
  Santhosh
  

  ---

  Human Knowledge Belongs To The World !!

• Eduard

  SSCommitted

  Points: 1761

  More actions

  September 15, 2009 at 8:46 am

  #1053834

  perhaps these 2 can help getting you started:

  SQL Server 2005 Books Online: How To: Encrypt a Column of Data

  or a sql server central article:

  http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/