Securing Databases (SQL Server Compact Edition)

The Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) Database Engine provides two features for securing local databases on the supported devices:

  • Password-protecting SQL Server Compact Edition databases
  • Encrypting SQL Server Compact Edition databases

SQL Server Compact Edition also provides connectivity security options. The connectivity between SQL Server Compact Edition and Microsoft SQL Server relies on correctly configuring the security models for both Microsoft Internet Information Services (IIS) and SQL Server. For more information, see Configuring and Securing the Server Environment.

In This Section

This topic covers the features that can be used to help secure a SQL Server Compact Edition database.

Topic Description

Password Protecting a Database

Describes the different ways to use password protection for a SQL Server Compact Edition database.

Encrypting a Database

Describes the different ways to use encryption in SQL Server Compact Edition databases.

Changing Passwords and Encryption Settings for a Database

Explains how to change the password and encryption settings.