Can I change a SQL Server Everywhere database's password?

Hi, I'm using the SQL Server Everywhere CTP on the desktop and haven't used SQL Server Mobile in the past.

I'm having some difficulty determining whether it's possible to change a SQL Server Everywhere database's password. Obviously authentication on a file-based SQL Server Everywhere database differs from that of server-based SQL Server database. Is it possible to change a SQL Server Everywhere database's password?

That said, I feel like I've made a decent search of the to change a SQL Server Everywhere books online. If it's not possible to change the password in place (i.e., without copying all data to a new file with a different password), please count this as a vote to add that functionality. Making a database password "permanent" lessens its effectiveness. Thanks,

Curt

Have you tried compacting the database? This was the way to go with SQL CE 2.0 - the compaction mechanism would create a new database with all the original's data and structure but then you had a chance to specify a new password.|||

Thanks, Jo?o.

Clearly I should have been looking under "Compact." :) I suppose if the password is used as an encyption key and setting a password implies using encryption then it was probably expedient to rewrite the password (and encrypted data) this way.

In the Compact docs:

You use the Compact method (the CompactDatabase method in native programming) to reclaim space in the database file. You can also use it to change database settings such as password and locale ID (LCID).

And in the CompactDatabase docs:

The CompactDatabase method reclaims wasted space in the local SQL Server 2005 Everywhere Edition (SQL Server Everywhere) database. This method can also be used to change the collating order, encryption, and password settings of the database.

|||

You can PASSWORD protect the database with out encrypting too. Set Password=xyz and Encrypt=false in connection string.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere