Post reply

Data Encryption

  • November 23, 2005 at 11:31 am

    #102953

    Hi, I want to know if is possible to encrypt an entire database in sql server 2000 or 2005 (Tables, Stored Procedures, Data, all database items).

    I need to develop a new project that involves Bank information and they want to encrypt all data, even dba can't see the data.

    Is it posiblle with Sql Server or with an external Tools and how.

     

    Thanks for any advice.

  • November 25, 2005 at 2:34 am

    #605806

    Hi,

    There is third party tool to encrypt your data like XP_CRYPT from http://www.activecrypt.com

    and other for SQL 2k. I not sure of SQL 2k5 on this area. SQL 2k only offer some

    stored procedure encryption that can be crack by third party tool.

    Anyway, if you got good solution on encryption on SQL 2k or 2k5, please let me know

    as I also looking at this area on SQL 2k.

  • November 25, 2005 at 3:59 am

    #605820

    Hi,

    Concerning SQL2K, I once read in the reasource kit that it was possible to encrypt the .mdf & .ldf files on NTFS, and have the account that run the SQLServer service hold the certificate. This would help encrypt the whole database at once without coalling encryption functions each & every time in your code.

    I don't know enough about W2K5 yet.

    Hope this helps,

    Jan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply