Post reply

Database level encryption

  • August 12, 2008 at 8:19 am

    #382222

    How do I setup SQL Server 2005 to encrypt only 1 database on a server of 20? All I want to do is encrypt the data at a resting state not during back and forth communication.

    Thanks in advance.

    Aaron

    Aaron
    MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
    https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard

  • August 12, 2008 at 10:25 pm

    #857164

    This is not a feature of SQL Server 2005. You'll have to either use Encrypting File System (operating system level) or a 3rd party product. SQL 2008 has Transparent Data Encryption (TDE) which is set at a per database level which does this.

    K. Brian Kelley
    @kbriankelley

  • August 13, 2008 at 5:39 am

    #857306

    That is what I thought.

    Thanks

    Aaron
    MCITP: Database Administrator, MCITP: Server Administrator, MCTS: Windows Server 2008 Active Directory – Configuration, MCTS: Windows Server 2008 Network Infrastructure – Configuration, MCTS: Windows Server 2008 Application Platform – Configuration, MCTS: SQL Server 2005, MCTS: Microsoft Exchange Server 2007 – Configuration, MCSE 2003, MCSA 2003, MCDBA, Security+, CCNA
    https://www.mcpvirtualbusinesscard.com/VBCServer/AaronChristenson/interactivecard

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

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