Share via

Database Properties - Set Password

  • Article

The Database Properties - Set Password dialog box in SQL Server Management Studio, SQL Server Management Studio Express, and Server Explorer in Visual Studio lets you change the SQL Server Compact 3.5 (SQL Server Compact 3.5) 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 3.5 database to be encrypted.

Note

If new password is specified, unencrypted source database will be encrypted to Platform Default mode. If the source database is encrypted, it will retain the source encryption mode and the database will be upgraded in-place.