SQLTeam.com | Weblogs | Forums

Windows reboots when trying to change SA password in SSMS


#1

I'm trying to reset the password "sa" account password and whenever I do I get a " Windows has encounter a critical problem and will restart automatically in one minute. Please save your work now.

I've been the password requirements for changing the SQL sa account, and I still get the "password violation" error. ( see attached). This happens no matter how complex the password is changed to.


#2

Windows%20Error Error%20SQL%20Admin


#3

Windows should have logged the error in the event log. Is that helpful?

This sounds like a problem that should be addressed to Microsoft. Have you opened an incident? They are reasonably priced and don't charge if you find a bug.

Are you really changing the "sa" password? Your screenshot implies a different account.

I'm assuming you've configured the account to ignore the complexity checks?

My other advice is to create a new admin account and disable the "sa" account.


#4

Perform the following steps:

  1. Turn on your computer with F8 pressed.
  2. Click Safe Mode option.
  3. Logon using Administrator level user.
  4. Click Start --> All Programs --> Accessories --> Run
  5. Run msconfig and click OK.
  6. Now Go to SERVICES tab and search for Gbp Service, uncheck it and click Ok.
  7. Restart and see if the problem is gone.

#5

Thank you. Creating a new "sa" account solved the issue.