Change password of SDF database file (SQL Server Compact 4.0)

0
votes

I would like to change the password of my SQL Server Compact 4.0 database. Is this possible out of Visual Studio 2010 (Ultimate, SP1)? Any help would be appreciated!

2
sql-server-cesql-server-ce-4

2 Answers

1
votes

Screen captures in VS 2012 Professional:

Server Explorer > Database Properties

Database Properties > Set Password

0
votes

OK, as soon as I posted the question here, I found the solution. First right-click on .sdf file in Visual Studio's Server Explorer and choose database properties.

enter image description here

In the new dialog there is a possibility to change the password:

enter image description here