How to: Secure a Database (SQL Server Management Studio)

  • Article

In this topic, you will learn how to help secure an existing Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) database from SQL Server Management Studio.

To secure a SQL Server Compact Edition database

  1. In Management Studio, open Object Explorer.

  2. In Object Explorer, click Connect, and then choose SQL Server Compact Edition.

  3. In the Connect to Server dialog box, choose the SQL Server Compact Edition database that you want to configure, and then click Connect.

  4. In Object Explorer, right-click the SQL Server Compact Edition database you just added and choose 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. You can also choose to encrypt the data in the database by selecting the Encrypt option. This option is available only if you provide a password for the database. Click OK to save your changes.

See Also

Tasks

How to: Create a SQL Server Compact Edition Database on a Server

Concepts

Securing Databases (SQL Server Compact Edition)

Help and Information

Getting SQL Server Compact Edition Assistance