Re: Securing the MDF file

Some folks have used EFS to accomplish this. With SQL 2000, I have used it
both successfully, and with dismal failures. The successes where with
attached exclusive RAID arrays, the failures where with clusters and NAS.

With SQL 2005, there are many excellent internal encryption capabilities
that you should explore. You may be able to accomplish your task relying
solely upon SQL Server (no external or third party code, etc.) -the best
option, in my opinion.

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"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: SQL Queries Questions
    ... "Seikyo" wrote in message ... > I use several SQL to do the stuff and Macro to link them I think. ... > will be a big trouble when the database get larger. ... Almost certainly there is a simpler way to accomplish what you want ... ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query
    ... What does the pound sign ... accomplish in sql? ... select * from tblYourTableHere ...
    (comp.databases.ms-access)
  • Subqueries and Aggregate Functions
    ... I am having trouble coming up with the correct SQL to accomplish a ... Most of the SQL I use is quite simple and I rarely have to ... SUMFROM tblEntryActivity act WHERE ... ent.colEntryID = act.colEntryID)) AS [Indirect Service Time], ...
    (comp.databases.ms-sqlserver)
  • Re: Group By - SQL Question?
    ... I WOULD LIKE THE SQL RESULTS TO LOOK LIKE THIS: ... How can I accomplish this - I am most concerned in ... RBrandt at Hunter dot com ...
    (microsoft.public.access.queries)
  • Re: Comparing SQL & MV solutions was Re: Legal Practice/Case M...
    ... I like to hear stories about successes and failures from either/both ... end-user and developer perspectives when products are converted from MV ... Was this is a conversion or did the company with an MV ... solution get bought by a company that already had an SQL solution? ...
    (comp.databases.pick)