Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: Encryption for sql server

    hey ppl..

    i am creating a client that can access straight into the sql db using vb.net.

    is there a way encrypt the data from the client and the sql server will decrypt the data and visa versa?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Your best choice is to use some flavor of VPN to get your data to the server safely. A poor alternative (although pure MS-SQL) is to use Named Pipes, which can do feeble encryption at relatively low performance.

    -PatP

  3. #3
    Join Date
    Feb 2005
    Posts
    36
    is there anyway to make a simple encryption? small enough so that it encrypts the data and it does not effect performance?

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    See if this helps you:

    http://www.developerfusion.com/show/4647/

    You would basically be storing the data encrypted. The problem is when you go to search the data of course. If you need to encrypt all traffic, you can look at what Pat said. I would recommend against it. There are also several hardward level tools for this, but they are expensive.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •