Re: MDF file level security from copying

From: Ayman (aimaimoni@hotmail.com)
Date: 05/25/02 

From: "Ayman" <aimaimoni@hotmail.com>
Date: Fri, 24 May 2002 23:43:36 -0700

Hi All,
I have the same concern of Stephen, I thought that there
is a way to protect the MDF files , specially in those
located on FAT like Windows 98 and Windows ME , but it
seems that the only way is to put it in EFS (NTFS) of
Windows 2000, which I think it is not 100% secure as the
recovery agent of that system could de-crypt it.

Is there are any other ways ??
Best Regards,

>-----Original Message-----
>Stephen,
>
>If you can restrict the application to Windows 2000, then
you can use
>Encrypted File System. For additional information, see
section "Using
>Encryption Methods" (adminsql.chm::/ad_security_93u6.htm)
in the SQL Server
>2000 Books Online.
>
>BTW, if you are concerned about the database schema, as
opposed to the
>actual data, then you are essentially out of luck. If a
competitor can
>purchase your product, then they can see your database
schema.
>
>Bottom line: the protection of intellectual property is
best addressed via
>legal mechanisms rather than trying to rely upon
technical solutions.
>
>-------------------------------------------
>BP Margolin
>Please reply only to the newsgroups.
>When posting, inclusion of SQL (CREATE TABLE ...,
INSERT ..., etc.) which
>can be cut and pasted into Query Analyzer is appreciated.
>
>"Stephen Schmid" <steve_schmid@msn.com.au> wrote in
message
>news:446101c1fe10$f5c8bd70$9ee62ecf@tkmsftngxa05...
>> How can I implement a security mechanism with a SQL
Server
>> database that protects me from someone copying the mdf
>> file while the sql server is stopped?
>> Once copied the database can be be simply attached on a
>> separate server and they have it.
>>
>> Background: product for market about to launch using
MSDE
>> 2000 for DBMS. Win98 min OS level. Our competitiors
would
>> love to get their hands on our database schema and they
>> will have access to the computer running our instance of
>> MSDE 2000.
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • Re: BizTalk 2004 MSDTC
    ... On my Windows XP, dev machine, I set ... and it still errors out when updating a remote SQL Server database running ... BizTalk 2004 Server, Visual Studio.Net, and local SQL Server DB ... The problem I am having is that with MSDTC ...
    (microsoft.public.biztalk.general)
  • Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... involving SQL Server Express 2005 on a Windows SBS 2003 R2 network. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
    (microsoft.public.windows.server.sbs)