Possible Duplicate:
gain admin access to sql express 2008

Is there any idea if we lost our password to login in database using sql express management studio? Is there any place where username and password saved on installation time of any sql server?


2 Answers 2


If it's SQL Server Express 2005-2008R2 and you cannot get in, you can use this method: http://www.netspi.com/blog/2012/08/16/sql-server-2008-local-administrator-privilege-escalation/


You can connect to DB with local Windows authetication and change the sa password.

Not the answer you're looking for? Browse other questions tagged or ask your own question.