Forgot sa password on MSDE

Last Post 03 Jan 2010 04:04 PM by J013-B. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
drfrye
New Member
New Member

--
31 Oct 2005 08:03 AM
Help! I have a client that forgot their sa password. They are on MSDE so there are no SQL tools. Any suggestions on how to find the password or reset it? Everything I've tried requires knowing the sa password to begin with before it can be changed.
J013-B
New Member
New Member

--
03 Jan 2010 04:04 PM
As the previous post said if the Built-in\Administrators login was not removed from the sysadmin role, any user with local admin on the box should be able to access the instance using osql -S <servername> -E, or on SQL 2005 and later sqlcmd -S <servername> -E to connect to the instance and reset the sa password.


Acceptable Use Policy
---