How to: Secure a Database (Visual Studio)

In this topic, you will learn how to help secure an existing SQL Server Compact database from Visual Studio 2010 Service Pack 1 2010 SP1.

To secure a database

1. In Visual Studio 2010 Service Pack 1, open Server Explorer.

2. In Server Explorer, right-click Data Connections, and then choose Add Connection.

3. In the Add Connection dialog box, choose the SQL Server Compact 4.0 database that you want to configure, and then click OK.

4. In Server Explorer, right-click the SQL Server Compact 4.0 database you just added and choose Database Properties.

5. In the Database Properties window, select the Set password page.

6. Enter the old password, if one exists, and then type a new password for the database. Click OK to save your changes. If you specify a non-blank password, the database is encrypted by default.

See Also

Concepts

Securing Databases (SQL Server Compact)