none
SQL Server Compact Edition Database Password Recovery / Reset RRS feed

  • 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

    Sunday, April 18, 2010 9:01 PM

Answers

  • 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.
    Monday, April 19, 2010 9:15 AM
    Moderator

All replies

  • 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

    Sunday, April 18, 2010 9:01 PM
  • 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.
    Monday, April 19, 2010 9:15 AM
    Moderator
  • 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.
    Friday, April 23, 2010 12:00 PM
    Moderator
  • I know the password for my sdf file, is it possible to remove this password?!

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

    Tuesday, July 3, 2012 5:49 PM
  • 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

    • Proposed as answer by mplaza Sunday, February 9, 2014 7:38 PM
    Wednesday, July 4, 2012 8:52 AM
    Moderator
  • We had the same issue in our company, we've been looking for the solution for 4 months... We found this tiny company that handled our case exactly like we wanted https://www.pelock.com/services/reverse-engineering/decrypting-an-encrypted-database-and-database-password-recovery

    We had CE database with a password and we couldn't access the data, they took the software, reverse engineered it and found the login routine and the password (it was encrypted within the application itself). I'm posting this, because we've not been able to find help anywhere else.

    Thursday, December 26, 2019 10:58 PM