Step 1: What to do after DBDefence installation

Step 2: Database encryption

Step 3: Accessing protected database

At this step you should have DBDefence already running.

Please make a backup of the database to prevent any accidental data loss !

Use DBDefence Protector to encrypt the database. Connect to the instance and select the database. The tool lists only unprotected and non-system databases.

Note: Database Encryptor requires administration privileges. If you use Vista and newer operating systems with UAC turned on you will get the warning. High level of privileges required to access database files which usually located in SQL Server Data folder which itself located in Program Files. Without admin rights it is not possible to access them. Windows XP users do not get any warnings.

Enter password in the edit box and press "Encrypt". Everything is quite straightforward. DBDefence will detach the database, encrypt it, attach and run simple test

Later when you will access the database you will need to enter exactly that password. Password is case sensitive.

For 1GB database encryption takes about 30 sec. on average developer workstation. Better systems with fast disk subsystem can produce much faster results.

Note: Free version can encrypt databases less than 77 MBs

After you press "Encrypt" you should see message about successful encryption and test.

That's all! Now you will need to learn how to access protected database.

Accessing protected database