Database Properties - Set Password
The Database Properties - Set Password dialog box in SQL Server Management Studio and SQL Server Management Studio Express lets you change the SQL Server 2005 Compact Edition (SQL Server Compact Edition) database password. Setting strong passwords is essential to the security of the system. Always use strong passwords.
Warning
You must close all open management dialog boxes before you change the database password. If you change the database password and then try to submit changes made in an open management dialog box, such as a table name in the New Table dialog box, you will receive an error message informing about the password mismatch.
Options
Old Password
Specify the old password.
New Password
Specify the new password.
Confirm Password
Re-enter the new password to confirm it.
Encrypt
Select the Encrypt check box if you want the data in the SQL Server Compact Edition database to be encrypted.