Post reply

SQL 2000 and Encryption

  • August 24, 2005 at 2:41 pm

    #168138

    Who has made this work?

    I am creating a database to hold certain passwords.  I am using SQL 2000 on a Win 2003 server.  I am thinking of using 2003's ability to encrypt a file (EFS) to protect the data from just being taken from the directory it is in and using Access Runtime and SQL logins to protect the data being viewed.

    Has anyone done this?  Can anyone give me a better way of creating a password database that only allows you to see the passwords you have the right to see?  I am just getting started and am researching my options.

    Any feedback would be greatly appreciated.

  • August 24, 2005 at 5:38 pm

    #584838

    put constraint in the password column is another option.

  • August 25, 2005 at 8:37 am

    #585011

    Can you expand on this?

  • August 25, 2005 at 9:29 am

    #585050

    We bought xp_crypt to encrypt our Credit Card numbers in SQL tables. Perhaps that would work for you.

  • August 25, 2005 at 2:29 pm

    #585175

    I just implemented EFS to encrypt the SQL data and log files in the file system. See the following article...

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

  • August 29, 2005 at 8:35 am

    #585859

    Awesome.  This is just what I was looking for.  I did a search for encryption on this site, funny how this one did not come up.  Oh well.

    Thanks again for your help!

  • August 29, 2005 at 10:45 am

    #585907

    I just noticed that this article is for Windows 2000.  EFS doesn't change much from 2000 to 2003 does it?  Looking through KB on the MS site doesn't give me much reason to believe that the 2000 article won't apply to my 2003 server.

    I am moving forward anyway with this but I would like to hear from anyone who believes that there are differences that need to be taken into account.

  • July 5, 2006 at 4:00 am

    #647444

    Hi,

    Regarding the EFS, I like to know the following issues

    1. Will the encrypted file still be encrypted after moving it to another NON-NTFS or NON-Windows OS ?

    2. How to let other system access the encrypted file without problem like some backup software or let other system access the encrypted file without any problem.

    Please advise

Viewing 8 posts - 1 through 7 (of 7 total)

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