subject: The easiest way to reset sql sa password [print this page] The easiest way to reset sql sa password The easiest way to reset sql sa password
One of my accompany complained that: I am not a reset forgotten windows password sql db administrator by any agency but I've been asked to displace sa countersign for a sql 2005 server. My affair is will alteration this countersign accept any aftereffect on applications that use sql 2005. They use Micro CRM 3.0, and I don't wish to agitate their service. The acumen they wish to displace the countersign is because they afresh bought a new accounting amalgamation that will tie into CRM, and the technicians are requesting the countersign to complete the install. In fact, MS SQL Server Countersign change windows password Unlocker can displace SQL countersign in no snap! Just install the sa countersign accretion affairs on the computer area the sql master.mdf is saved. MS SQL Server Countersign Unlocker accesses to the master.mdf book anon and lists all the users to the database. For accessing the master.mdf smoothly, the SQL countersign accretion affairs detects and stops the active windows password reset software SQL Services automatically
First things first, try the bedfellow account. Simply admission Guest' in the user name box, or bang on the annual labeled Guest. Sometimes humans will accept these annual
enabled after even acumen it, and abounding times they are larboard after a password. If this doesn't plan for you, or you crave a little bit added admission than the Bedfellow
annual provides, apprehend on.
Next up is Windows XP's congenital in Administrator' account. This annual is created during Windows XP installation, and is not attainable beneath accustomed circumstances.
Abounding computers, abnormally those that appear from Dell or agnate companies, leave the Administrator annual after countersign protection.
To get to this account, cossack the computer into safe mode. You can do this by captivation down the F8 key during startup, and selecting Safe Approach from the Windows cossack
menu. Once the computer boots into Safe Mode, you'll accept admission to the Administrator account. Things will attending a little awe-inspiring in Safe Mode, but don't worry,
things will be accomplished if you cossack commonly again.
Once Windows finishes booting, try accepting into the Administrator account, abrogation the countersign acreage blank. If you're clumsy to get in this way, again there is a
countersign on the account, and unless you can assumption it, you're traveling to accept to try something else, and you can skip the next paragraph. If you're in, again there