How to set a Password on Portable Sql Express Database File?

[alim]

Add->Add New Item-> Sql Database


We can create database using sql expression edition but how can we protect them.

I mean how can i set a password. Do I have to install any other application to protect this MDF file .



Thanks in advance

 

[JohnH]

Securing Your SQL Server 2005 Express Edition Server
As you can read in that article you can use SQL Server 2005 Management Studio (Express) to configure user access. Also be aware that this type of protection is only valid through regular application based access where you control the user logins, you can't prevent a System Administrator (SA) to attach your database file and get full access to it with another interface. This is however possible with Sql Compact which is a purely filebased database that does not attach to a higher level service, see for example Password Protecting a Database

 

[alim]

thanks a lot @JohnH for your help.

 

[alim]

ohh.. i am using .Net 2.0 so I can't use Sql Compact 3.5, is there any other way to protect my database from everyone

 

[JohnH]

If you're using VB 2005 Express go for 2008 Express instead. Else you could check out the previous version, Compact 2005 (3.1) and this tools package Download details: SQL Server 2005 Compact Edition Tools for Visual Studio 2005 I don't know how well or if it integrates with Express.

 

[alim]

thanks again for your help