Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

How to find the SQL Server Service Account

30 April,2015 by Tom Collins

Question: How can I find my SQL Server Service Account?

Answer: The SQL Server Service account is stored as a Windows Registry Key.There are a number of methods to access the service account details.

Method 1 – Get the SQL Server Service Account using t-sql.

Note: Only valid from SQL Server 2008 R2 SP1


SELECT servicename, service_account
 FROM   sys.dm_server_services


Method 2 – Check the services.msc console , find the service and LogOn As .


Method 3 – SQL Server Configuration Manager

In the command line type “Configuration Manager SQL Server” , this will open the SQL Server Configuration Manager . You should see the service account


 If these methods cannot help - you do have the added option of using Powershell and executing the Get-Service cmdlet. Read how to use Get-Service on SQL Server - Working with Windows Services Examples and Powershell

Read More on SQL Server configurations

SQL Server database files configuration checklist

SQL LOG FILE AUTOGROW performance ... - SQL Server DBA

SQL Server Surface Area Configuration ... - SQL Server DBA





Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on How to find the SQL Server Service Account | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer