SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    23
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Encrypting MSSQL database

    I have to encrypt a Microsoft SQL server database with "128 bit encryption". I use php and ADODB to connect to the database. I have no experience whatsoever encrypting a database. How can I do it? is it possible to keep using ADODB, or will I have to use "SQL Server Driver for PHP"? do I need to change my DB structure (changing field types, etc)?
    Thank you for the help

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,576
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    I'd start with the SQL books online, lots of different encryption options exist. Quite a bit depends on which exact version of Sql Server you are using.

    Also, are they talking about encrypting the connection or encrypting the data itself -- that is two different problems.

    I don't think ADODB and Sql Server Driver for PHP are mutually exclusive, but I haven't done PHP since either became viable so I'm not certain.

  3. #3
    SitePoint Member
    Join Date
    Jun 2007
    Posts
    23
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think they are refering to encrypting the database. They have SQL Server 2000 and I have a test server with SQL Server 2005. I need something that can work in these two versions of SQL server.

    I know there are many ecryption types. I really dont care which one I use. The only requisite is that it has to be 128 bits.

    What I dont know if the encryption must be handled by the database itself or by PHP. For example, maybe I can do a function in PHP that encrypts a string using AES and then storing that in a binary field in the database. Then retrieve it and decrypt it using PHP. I dont know if this is standard procedure, or there is something that can handle encryption by the database itself. But then I dont know if the queries have to change, and this is why I dont know if I can use ADODB abstraction layer to handle those special queries.


Bookmarks

Posting Permissions

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