Post reply

Sql Server 2000 Data/ Database encryption

  • April 3, 2008 at 5:38 am

    #95905

    hi,

    i need to design some kind of encryption strategy for our system (payroll). i need to encrypt the data in such a way such that even the system administrator should not be able to access the data.

    in this case encryting the d/b or encrypting the data will be better? which tools can i use.

    incase of further enchancements of the project after the data is enryted how do i upload new chages unto the d/b....can any body suggest some tools that will do this.

    basically it should be a full proof system

    version -- sql server 2000

    windows 2000 server

    thanks for the help.

  • April 3, 2008 at 6:00 am

    #797730

    Hi Sharon,

    Encrypting at the data level would be suggested strategy, as encrypting the entire database will be time consuming. Here's is a great article to get you started:

    http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2000encryptiontools/2344/

    Thanks,

    Phillip Cox

    MCITP - Database Administrator|MCTS - SQL Server 2005|MCP - SQL Server 2000

  • April 3, 2008 at 6:53 am

    #797763

    thanks for the info but are there any 3rd party tool that can do this ?

  • April 3, 2008 at 7:06 am

    #797775

    Hi Sharon,

    I assume you do not want to code, so here are some tools I have worked with in past:

    Here are some tools:

    http://www.netlib.com/

    http://www.activecrypt.com

    Thanks,

    Phillp Cox

  • April 6, 2008 at 6:43 am

    #798847

    thanks philips for your help. i will dig more into it.

Viewing 5 posts - 1 through 4 (of 4 total)

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