Post reply

Encrypt Database

  • August 3, 2005 at 11:10 pm

    #186876

    How can i Encrypt Database SQL Server 2000 and MSDE2000 ?

  • August 4, 2005 at 4:38 am

    #579490

    You can't do it directly but should be able to encrypt information comming in from a web server or application fairly simply though.

    I know SQL 2000 has some inbuilt encryption functionality but to be honest most people know how to get round that

    One issue I should point out is that the performance hit in and again out of the database will need to be included when considering how fast the system is working, depending on how you do the encryption/decryption it could significantly add to the time.

  • August 4, 2005 at 5:04 am

    #579494

    thanx sir but i have this problem-

    "I plan to use an MSDE (or Sql Server Express) database in my single-user

    application. My problem is that the mdf file will be accessible (at least

    readonly) to anyone using the application. How can I be sure that the user

    cann't copy the mdf file and attach it to another server and view all the

    information he wants to?"

    what can i do for this?

  • August 4, 2005 at 5:12 am

    #579497

    ah, so you want to encrypt the actual physical files rather than the data.

    That's already possible in the OS, just login as the account that SQL is running under and encrypt the folders using that account.  That way it can always access them but no-one else can.

    Mike

    PS. I think/hope I got this right (2003 server onwards) if not please feel free to correct me

  • August 4, 2005 at 5:35 am

    #579505

    can u pls explain this solution

    thanx

  • August 4, 2005 at 10:07 am

    #579649

    I am very curious about this as well.  It comes at a perfect time since I need to develop a VERY secure database and don't want anyone simply getting access to the folder were it resides and stealing it.

    More information on the encryption would help me immensely.

  • August 4, 2005 at 10:12 am

    #579655

    I'm just about to head off home for the evening but if no-one has filled in the process by tomorrow morning i'll post it then.

    Mike

  • August 5, 2005 at 9:20 am

    #580075

    Log on using the same Windows account that SQL Server is running under.

    To encrypt a file or folder

    1. Open Windows Explorer.
    2. Right-click the file or folder that you want to encrypt, and then click Properties.
    3. On the General tab, click Advanced.
    4. Select the Encrypt contents to secure data check box.

     

  • August 5, 2005 at 9:24 am

    #580077

    Oops, sorry I forgot to check back to see if anyone had posted a reply about this one.

    Steve's right in what he's saying but remember to do it as the login that is running the SQL service or you might have problems accessing it.

  • August 5, 2005 at 10:00 am

    #580098

    You might check out the following article:

    Implementing Encrypting File System (EFS) with SQL Server

    http://qa.sqlservercentral.com/columnists/bkelley/implementing_efs.asp

     

     

Viewing 10 posts - 1 through 9 (of 9 total)

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