How to find the Service Account of SQL Server Service

Dynamic management views are very much useful when it comes to troubleshooting or collecting server and database related configuration information.

The sys.dm_server_services provides the information about the service name and the service account under which the service is running etc.,

select servicename, service_account from sys.dm_server_services

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: