Securing an MDF file

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brian McGuigan (McGuigan_at_discussions.microsoft.com)
Date: 07/27/04


Date: Mon, 26 Jul 2004 21:47:03 -0700

We are creating and installing a custom application using an MDF file under SQL Server 2000. We create our own MSDE Instance to deploy our Aplication. We wish to protect both the data and the structure of this file from a Database Adminisatrator who has another SQL Server installation on the same machine. Is this possible and how do we go about it? Can we assign Password Protection at the overall MDF File level?