TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick query, or wade through the dialog boxes for the SQL Server services top see what user they are running as. I prefer the query, however this only runs on SQL Server 2008R2 SP1 or newer. Lets hope you are not running on a version older than that in todays world. If you need help upgrading contact us.
Here is the query that I use to look up the name each SQL Service is running as:
SELECT servicename, startup_type_desc, status_desc, service_account
FROM sys.dm_server_services
And here are some sample results:
A quick and easy way to look up what user the SQL Server services are running as.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Leave a Reply