How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179

Question: How to Find Service Account for SQL Server and SQL Server Agent?

Answer: As they say – There are more ways than one to skin a cat. In this blog, we will find multiple methods to find out service account used for SQL Server service and SQL Agent Service

Method 1 – SQL Server Configuration Manager

We can open SQL Server Configuration Manager for respective version. Once opened, click on “SQL Server Services” and then look for “Log On As” column to get service account.

Method 2 – Services applet or services.msc

Start > Run > Services.msc

Method 3 – Using T-SQL

In new versions of SQL Server, there is a catalog view – dm_server_services which can be used to get same details.

SELECT servicename, service_account
FROM sys.dm_server_services
GO

Method 4 – Using ERRORLOG

First, you should know how to get to ERRORLOG file for an instance. There are multiple ways. Refer my earlier blog on the same topic.

SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

In ERRORLOG, we can look for line like below. (mostly Line # 9)

2018-06-22 20:00:01.190 Server       The service account is ‘NT Service\MSSQLSERVER’. This is an informational message; no user action is required.

Do you know of any other method?

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Log, SQL Scripts, SQL Server, SQL Server Security, SQL Server Services
Previous Post
How Much Work Each Processor (CPU) is Doing in SQL Server? – Interview Question of the Week #178
Next Post
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180

Related Posts

2 Comments. Leave new

  • Ramón Quintana
    May 29, 2019 12:42 am

    Hi, I got a error after to know the account name:

    WMI Povider error:
    The service cannot be started, either because it is disabled or because it has no enable devices associated with it
    [0x80070422]

    Reply
  • Sydney Croud
    April 16, 2021 2:54 am

    Why does this not give the results for the SQL Reporting Services. That is odd.

    Reply

Leave a Reply

Menu
Exit mobile version