How to find the SQL Server Service Account

30 April,2015 by Jack Vamvas

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
 GO

 

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

  Services_log_on_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

  Services_ss_config

 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: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

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

Working...
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.

Working...

Post a comment on How to find the SQL Server Service Account


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer