Re: MSDE Encryption?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: TomB (shuckle_at_hotmailXXX.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 14:07:05 -0400

Andrea thanks for your response.

So, there's no built in encryption. That's what I suspected.

Any suggestions on securing the msde files on a laptop?

My thinking is that if someone stole the laptop they could access the files
(*.mdf), copy them and remount them on their own sql server, and therefore
have sa access.

Makes me think that maybe using xml files and encrypted folders would be
safer.

Thanks
TomB

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:2r0hkfF14i6i4U1@uni-berlin.de...
> hi Tom,
> "TomB" <shuckle@hotmailXXX.com> ha scritto nel messaggio
> news:O7wPcDNnEHA.3684@TK2MSFTNGP10.phx.gbl...
> > I'm considering writing an offline application that will replicate a
local
> > msde with a central sql server.
> >
> > I'm wondering if there's any way of securing the msde? What's to stop
> > someone from taking the mdf file and loading it up on a different
machine?
> > Can I encrypt.
> >
>
> you have the same possibilities offered by the full blown SQL Server
> edition... actually none =;-D
> ok, in order to protect the physical files, you can protect the folder(s)
> hosting the files them self, restricting physical access, but a Windows
> admin could move them at desire, as, implementing the required SQL Server
> privileges managements, a malicious sysadmin can do...
> but in such circumstances I'd argue you should consider to fire your
> sysadmins...
> direct encryption is not included in SQL Server/MSDE, but you can resort
on
> 3rd parties external tools like http://www.activecrypt.com/index.htm ,
> http://www.netlib.com/ , google for further...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>

Relevant Pages

  • Re: Database securing problem
    ... My impression is that SQL Server ... that might be one of the reasons why MSDE 2000 ... >> the content of a database, any sort of encryption (even ... >> database is to stop the MSDE, copy the mdf and ldf files ...
    (microsoft.public.sqlserver.security)
  • MSDE Connectivity on/off Network
    ... We have an application that uses SQL Server or MSDE. ... local users laptop. ... unable to connect to "" when they are disconnected from the network. ...
    (microsoft.public.data.oledb)
  • Re: Replication with SqlServer and MSDE
    ... You can set up replication with one SQL Server and multiple MSDE instances. ... how replication works with Identity fields (I insert a Order in my laptop ...
    (microsoft.public.sqlserver.programming)
  • Re: Protocol encryption
    ... > MSDE? ... but I don't know how to install certificate in MSDE) ... article about setting a SSL encryption... ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: Replication between MSDE and SQL Server 2000
    ... replication process between the SQL Server 2000 and the laptop MSDE? ... As I am investigating the database to do this project, MSDE is an option, ... The reason why I need to do the replication is the sales persons bring the ...
    (microsoft.public.sqlserver.replication)