question

Cataster-7485 avatar image
1 Vote"
Cataster-7485 asked Cathyji-msft commented

How to reset the logon for the sql server services?

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?

125415-image.png


sql-server-general
image.png (63.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
2 Votes"
Cathyji-msft answered Cathyji-msft commented

Hi @Cataster-7485,

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.
    125482-screenshot-2021-08-23-104627.jpg
    125474-screenshot-2021-08-23-104640.jpg

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Cathyji-msft oh i see, thanks Cathy. For reference, the sql agent accounts are: NT SERVICE\SQLAGENT for default instance and NT SERVICE\SQLAGENT$<instance name> for named instance.

0 Votes 0 ·