Re: Ecrypting a database

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 11/05/03


Date: Wed, 5 Nov 2003 16:02:11 +0530

I am not sure why you want to encrypt the folder. You can have proper ACL's
to block the user from listing or viewing your database files. And you can
restrict using database roles security features by giving access to your
application only.

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"krygim" <krygim@hotmail.com> wrote in message
news:OzkwbK3oDHA.1072@TK2MSFTNGP09.phx.gbl...
> I have a SQL database which will only be accessed only by an application
> (written by me). I want to put the database into a Windows 2000 encrypted
> folder so that even the network domain administrator will not be able to
> view the content (bypassing my application). Is this viable? If so, which
> Windows account do I need to log in to encrypt the folder? Do I need to
log
> in as the SQL service account to do the encryption?
>
>
>
> TIA
>
>


Relevant Pages

  • RE: ASPNETDB.mdf
    ... An end user instance of a sqlexpress database runs just fine in the app_data ... folder in a website. ... It works fine with sql authentication. ... can't buy a complere SQL server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL CE
    ... from emulator, use the File Explorer in the emulator to map to a ... shared folder on your desktop and copy and paste the sdf file to ... >> if you create a sql ce database programmatically using ... >> you cannot create a SQL CE database directly on your desktop ...
    (microsoft.public.sqlserver.ce)
  • Re: Securing fields
    ... definitely encrypt it. ... I'm planning on storing credit card numbers in my SQL database for online ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MDF file vs. Local Sql Server...whats the connection?
    ... the file that's in the app_data folder is a SQL ... Server database, but it's not technically attached to the database as the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Server 2000 / 2005 Encryption
    ... You require 3rd-party tools even when using the native SQL 2005 encryption ... to encrypt your SSL connections will be different. ... But you mentioned Excel cannot decrypt this information. ... Requests to the web services would connect to the database and invoke ...
    (microsoft.public.sqlserver.security)