0

We have changed the login/startup account of our SQL Server service, to use a domain service account. However, we are experiencing issues with this account, and need to revert back to using the local NT Service\MSSQL$[namedinstance] account for now.

Is there a way of doing this? When prompted for the password in SQL Server Configuration Manager, what does one enter? We never set a password for this previously, but it appears to require one.

The account name is invalid or does not exist, or the password is invalid for the account name specified. [0x80070421]

  • 1
    It looks like you're trying to revert to a managed service account. If so, your not going to have access to the password. I found this article which may help: mssqltips.com/sqlservertip/5334/… It uses PowerShell to set the service account for a SQL server instance. – S M Sep 9 '18 at 7:26
  • Thank you. In the end we had to resort to using the built-in "Local System" account (which requires no password) to get the instances working again, until we can get some gMSA's implemented. – James D Sep 10 '18 at 10:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.