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

  • Article

In this topic, you will learn how to help secure an existing SQL Server Compact 3.5 database from SQL Server Management Studio.

To secure a database

  1. In Management Studio, open Object Explorer.

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

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

  4. In Object Explorer, right-click the SQL Server Compact 3.5 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. Click OK to save your changes. If you specify a non-blank password, the database is encrypted by default.

See Also

Tasks

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

Concepts

Securing Databases (SQL Server Compact)

Help and Information

Getting Assistance (SQL Server Compact 3.5 Service Pack 1)