Click here to Skip to main content
Click here to Skip to main content

Encrypt Password Field in SQL Server, Registry Information & Query String

, 13 Jan 2003
Rate this:
Please Sign up or sign in to vote.
How to encrypt the database password field, registry information and query string.

Introduction

Normally, web developers do not take keen interest to secure the query string and connection string information which usually reside in the registry and the user passwords which reside in the user registration database table. When I was creating a web-based application in ASP.NET, I decided to use these three encryptions to fully secure my application.

.NET provides us the new Cryptography classes to encrypt and decrypt the data whenever used.

I would like to discuss these three issues one by one.

Encrypt Password field in SQL Server

This is the a common practice of developers, not to encrypt the user-login passwords in the database table fields. If anyone has access to the database tables, he can easily use these passwords to enter into the site anytime. So to avoid this situation, I used, .NET’s Cryptography classes.

The business logic which I used is that, when a user is added through my web application, on form submit event, I first get the user’s information from the form fields, encrypt the employee’s password and then submit the entire information into the user registration table. The password information is encrypted in the user registration table. Now, when the user enter into the application, provides userid and password, I just encrypt the user provided password and match it with the employee table’s password, so I don’t need to decrypt the database stored password again and again.

Encrypt Registry Information in SQL Server

Typically, most of the developers including me think that the windows registry is the best place to store key information like connection strings. But these information in the registry are not encrypted and if anyone has access to the server he can easily get all the secure information including the database passwords etc. To avoid this situation also, I use .NET’s Cryptography classes to save the key information residing in the registry.

Encrypt Query String

Often developers pass information from one page to another by using query string, without encrypting those sort of information. Let’s take a scenario where (e.g. it is necessary to encrypt the information contained in the query) I pass the area name (e.g. TownId) from one to another page and on the basis of that TownId I want to get some information from the database. If the user change the TownId in the address bar of the browser and refresh the web page, then this changed TownId will pass and the information related to the users changed TownId will be viewed. So by doing this, the user is able to get all the towns' information whether he has access to all the other towns' information or not.

By the .NET’s Cryptography classes, we can send these information first by encrypting and after receiving, do the reverse process, i.e. to decrypt and use that information.

I have made a class named Utilities and imported the following classes,

Imports System
Imports System.IO
Imports System.Xml
Imports System.Text
Imports System.Security.Cryptography

Two public shared functions named EncryptText and DecryptText with one argument of type string are made.

From an ASP.NET page, just provide the text that you want to encrypt/decrypt into this function and it will return you an encrypted/decrypted text depending upon the function you use.

The EncryptText function internally uses the Encrypt function which uses two parameters: one is the user’s text and other is the encryption which must be on eight digit code. Same as the case for DecryptText function, it uses Decrypt function.

The source code for the function is given below:

' Encrypt the text
 Public Shared Function EncryptText(ByVal strText As String) As String
            Return Encrypt(strText, “&%#@?,:*")
 End Function

'Decrypt the text 
Public Shared Function DecryptText(ByVal strText As String) As String
            Return Decrypt(strText, "&%#@?,:*")
End Function

'The function used to encrypt the text
Private Shared Function Encrypt(ByVal strText As String, ByVal strEncrKey _ 
         As String) As String
      Dim byKey() As Byte = {}
      Dim IV() As Byte = {&H12, &H34, &H56, &H78, &H90, &HAB, &HCD, &HEF}
   
  Try
      byKey()  = System.Text.Encoding.UTF8.GetBytes(Left(strEncrKey, 8))
      
      Dim des As New DESCryptoServiceProvider()
      Dim inputByteArray() As Byte = Encoding.UTF8.GetBytes(strText)
      Dim ms As New MemoryStream()
      Dim cs As New CryptoStream(ms, des.CreateEncryptor(byKey, IV),_
                   CryptoStreamMode.Write)
                cs.Write(inputByteArray, 0, inputByteArray.Length)
                cs.FlushFinalBlock()
                Return Convert.ToBase64String(ms.ToArray())
                
  Catch ex As Exception
                Return ex.Message
  End Try
  
End Function
 
'The function used to decrypt the text
Private Shared Function Decrypt(ByVal strText As String, ByVal sDecrKey _ 
           As String) As String
     Dim byKey() As Byte = {}
     Dim IV() As Byte = {&H12, &H34, &H56, &H78, &H90, &HAB, &HCD, &HEF}
     Dim inputByteArray(strText.Length) As Byte
      
  Try
        byKey = System.Text.Encoding.UTF8.GetBytes(Left(sDecrKey, 8))
                Dim des As New DESCryptoServiceProvider()
                inputByteArray = Convert.FromBase64String(strText)
                Dim ms As New MemoryStream()
                Dim cs As New CryptoStream(ms, des.CreateDecryptor(byKey,_ 
                 IV), CryptoStreamMode.Write)
 
                cs.Write(inputByteArray, 0, inputByteArray.Length)
                cs.FlushFinalBlock()
          Dim encoding As System.Text.Encoding = System.Text.Encoding.UTF8
         
       Return encoding.GetString(ms.ToArray())
       
    Catch ex As Exception
       Return ex.Message
    End Try
    
End Function

Conclusion

I have shown here the three main areas where you should use encryption mechanism to secure your web-application. If you have any query or difficulty to implement it, please feel free to email me at: adnanahmed235@yahoo.com.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Syed Adnan Ahmed
Architect Version 1
Ireland Ireland
Adnan Ahmed is SharePoint Architect in Version 1(http://www.version1.com), the IT Consulting Company in Ireland and has involved with many large enterprises to help them realise real benefits of SharePoint 2007|2010.
 
SharePoint Architect | Blogger | IT Evangelist | MCPD SharePoint 2010 Developer| MCITP SharePoint Administrator 2010
 
Email: adnan.ahmed@live.ie
Owner: http://www.mossgurus.com
http://www.sp-blogs.com
Linked In Profile: http://www.linkedin.com/in/syedadnanahmed
 
My Blogs:
http://www.sp-blogs.com/blogs/adnan

Comments and Discussions

 
General10x! Excellent! Pinmemberyasp10-Apr-10 5:33 
Generalwhy does my encrypted string always end with '=' [modified] Pinmemberolibenu11-Jan-10 7:33 
Questionerror Pinmemberprabupep6-Jan-10 20:59 
QuestionHow do you protecting the code PinmemberMember 211249710-Feb-09 5:53 
QuestionError Pinmembermrichar314-Nov-08 6:30 
AnswerRe: Error Pinmembermrichar317-Nov-08 4:37 
Sorry... i see that this error was already addressed.
GeneralThank you Pinmemberm-chaos18-Feb-08 16:59 
GeneralError PinmemberNaderrafiee6-Jan-08 21:47 
QuestionRe: Error PinmemberEng_MR24-Dec-08 6:01 
GeneralTwo other related encryption articles in CodeProject ... PinmemberTony Selke27-Sep-07 6:56 
GeneralExcellent Code PinmemberSeaCrab25-Jun-07 5:57 
QuestionEncrypt and Decrypt in ASP.NET using C# Pinmembersssabi16-May-07 1:14 
AnswerRe: Encrypt and Decrypt in ASP.NET using C# Pinmemberbyterman2k15-Jul-07 2:42 
GeneralRe: Encrypt and Decrypt in ASP.NET using C# PinmemberNarind3r7-Aug-07 5:17 
GeneralRe: Encrypt and Decrypt in ASP.NET using C# Pinmemberfabrizio.magosso23-Oct-07 2:20 
QuestionQuerystring issue Pinmemberinspoiehfkdbc26-Apr-07 5:46 
GeneralRe: Querystring issue Pinmemberstixoffire1-Apr-08 23:23 
GeneralGreat job, worked the first time Pinmemberjohndsc23-Mar-07 0:18 
GeneralPretty good one. Pinmemberr_maiya19-Mar-07 7:50 
GeneralGood one! PinmemberCharuT8-Nov-06 19:05 
GeneralRe: Good one! PinmemberCharuT8-Nov-06 19:24 
GeneralProblems about RSA Password encryption Pinmemberpuriamrik10-Oct-06 2:47 
GeneralYou made a excellent job Pinmemberbritneyssssers29-Aug-06 10:32 
Generalthanks Pinmemberyusufziya10-Aug-06 0:04 
QuestionCan you call this from SQL? Pinmemberja9282-Aug-06 11:41 
GeneralTanx PinmemberGayuDam23-Jun-06 0:20 
GeneralRe: Tanx Pinmemberprabupep6-Jan-10 21:06 
Generalnice code Pinmembertjandrasa18-Jan-06 9:26 
QuestionWhere to store the key? Pinmembermpvbrao29-Jul-05 1:43 
AnswerRe: Where to store the key? Pinmemberstixoffire12-Jul-06 16:30 
GeneralRe: Where to store the key? Pinmembermpvbrao14-Jul-06 3:03 
Generaltest PinsussAnonymous17-Mar-05 12:54 
GeneralRe: test PinmemberChristian Graus17-Mar-05 13:11 
GeneralEasy Way :p Pinmemberzorrer17-Nov-04 21:28 
GeneralRe: Easy Way :p Pinmembermrkyle8-Sep-05 21:04 
GeneralRe: Easy Way :p PinmemberCSharpner.com31-Jan-07 9:31 
QuestionHow to retrieve each parameter in the QueryString ? PinmemberJohann Frot9-Nov-04 21:09 
AnswerRe: How to retrieve each parameter in the QueryString ? PinsussAnonymous18-Aug-05 11:57 
AnswerRe: How to retrieve each parameter in the QueryString ? Pinmemberkarthik2al7-Mar-07 0:10 
GeneralUsed this article to encrypt passwords for users table PinmemberSyed Irtaza Ali13-Jun-04 23:45 
QuestionEncrypting query string in datagrid link? Pinmemberocbka2121-Jan-04 16:25 
Generalgetting error msg PinmemberAnnie Bhatia18-Jan-04 17:56 
GeneralRe: getting error msg Pinmemberharina2-Jun-04 23:08 
Generalsame in c# if you like Pinsusssventheprogrammer22-Oct-03 0:10 
GeneralRe: same in c# if you like PinsussAnonymous13-Oct-05 23:33 
GeneralKerberos Pinmemberreso88@hotmail.com15-Sep-03 1:51 
GeneralEasier Way PinsussAnonymous11-Mar-03 4:47 
GeneralRe: Easier Way -- No Pinmemberdeadline22-May-03 10:21 
GeneralRegarding QueryString PinmemberHemant Kurdia21-Jan-03 18:14 
GeneralHTTP_REFERER is unreliable PinsussAnonymous24-Oct-05 5:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 14 Jan 2003
Article Copyright 2003 by Syed Adnan Ahmed
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid