SQL Server Compact Edition Database Password Recovery / Reset

Question

Hello,

We have an old SQL Server Compact 3.5 SP1 database that we would like to retrieve some data from.  Unfortunately, we have no clue what password was used to protect it and the person who created it has left the company.  Is there anyway to reset the password and/or retrieve the data from this database?  Or are we simply out of luck?  Any help would be greatly appreciated.  Thanks.

Brian P. Hamachek
President & CEO
SynergeTech Solutions

Answer 1

Hello,

We have an old SQL Server Compact 3.5 SP1 database that we would like to retrieve some data from.  Unfortunately, we have no clue what password was used to protect it and the person who created it has left the company.  Is there anyway to reset the password and/or retrieve the data from this database?  Or are we simply out of luck?  Any help would be greatly appreciated.  Thanks.

Brian P. Hamachek
President & CEO
SynergeTech Solutions

Answer 2

I am afraid you are out of luck, unless you find the password - or you could try brute force :-)

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 3

Cray,

This will not help on a SQL Compact password protected database file.

---

http://erikej.blogspot.com Erik Ejlskov Jensen - Please mark as answer, if this was it.

Answer 4

I know the password for my sdf file, is it possible to remove this password?!

---

º°\"~`\"°º×ÐÕÑ'T yÕÚ THíÑK ÍT§ MÅGí©×º°/"~`/&

Answer 5

Yes, use SqlCeEngine.Compact, with a connection string without the password.

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog