T-SQL Script to Return the Service Accounts of SQL Server and SQL Agent Services


/* This script reads out the names of sql server service account and sql server agent service account
Author:Ning Xu Date: 2010-09-16 Applied version: 2000, 2005, 2008 */

DECLARE @serviceaccount as varchar(50)
EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER', N'ObjectName', @serviceAccount OUTPUT, N'no_output'

SELECT @Serviceaccount as SQLServer_ServiceAccount

EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT', N'ObjectName', @serviceAccount OUTPUT, N'no_output'

SELECT @serviceaccount as SQLAgent_ServiceAccount
go