How to reset the logon for the sql server services?

Question

I changed the logon from NT service accounts to my local account at some point for testing purposes. Now I want to reset this logon back, however, I do not know the credentials!

Is there a way to reset this back to the default logons? Or do i have to uninstall/reinstall sql server so that it resets back to the NT service account logons?

Answer 1

Hi @Cataster ,

You can change this through SSCM(SQL server configuration manager). Please follow below steps;

1. Open SQL Server Configuration Manager and select the SQL Server Services page.
2. Double-click on the service you want to configure. The Properties dialog box opens automatically on the Log On page.
3. In Log on as, choose this account, type NT Service\MSSQL$<instance name> for named instance or NT Service\MSSQLSERVER for the default instance.
4. Leave the Password and Confirm password fields blank. Click on Apply. It will restart your service.
   
   

Change the SQL server agent service account like above steps.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.