Forgot sa password on MSDE

Last Post 03 Jan 2010 03:04 PM by J013-B. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
drfrye
New Member
New Member

--
31 Oct 2005 07: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 03: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.
You are not authorized to post a reply.

Acceptable Use Policy