Re: Securing the MDF file

First off, who is this 'someone'? Are you talking about some random user or
an authorized user with access to the server? If it is the latter, then you
will want to go the extra mile as was suggested in other posts.

It is a best practice to secure all directories created by the installation
of SQL Server to the SQL Server service account, the DBAs, the
Administrators (if different than DBAs), and the local SYSTEM account.

Nobody should be stopping your services and copying your databases like
that. I think looking into a more proactive approach would do you better,
which would be to research how to harden your SQL Server's security.

"Ken Hundley" <KenHundley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29A512D9-C866-4755-A072-DCF3CEC61447@xxxxxxxxxxxxxxxx
Is there anyway to secure a database so that if someone stops the server
and
copies the MDF file to a different system it will prevent them from
opening
the file and reading the information in that database file?

Thanks


.

Relevant Pages

  • Re: Connection string for MSDE 2000
    ... database file by specifying a file name in connectionString. ... server with SQL Server Express 2005 installed locally. ... i've tried using the following connection string in my ...
    (microsoft.public.sqlserver.msde)
  • Re: How do I use sp_configure user instances enabled
    ... Rick Byham, SQL Server Books Online ... I have a running version of SQL SERVER Express on my system and whether I try to attach to the database file using Server Managment Studio Express or through Viusal Studio 2005 pro I am getting the same error message: ... Generating user instances in SQL Server is disabled. ...
    (microsoft.public.sqlserver.connect)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)