Database Simplified Headline Animator

Database Simplified

Monday 17 October 2011

Query To Find SQL Server Service Account

SQL Server Services Account are stored in registry keys. You can read those key using built-in stored procedure “xp_instance_regread”.  These account information are stored under following keys HKEY_LOCAL_MACHINE --> SYSTEM --> CurrentControlSet --> services –> InstanceName

Instance Name: It is MSSQLServer for Default Instance. and if you have named instance then it is MSSQL$instancename. For example if you instance name is “Server\Prod” so your instance will be MSSQL$Prod.

Now you can use following query to find service account Name of SQL Server Service.



DECLARE @ServiceaccountName varchar(250)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE', N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',
N'ObjectName',@ServiceAccountName OUTPUT, N'no_output'
SELECT @ServiceAccountName

Similarly you can also get Account Name For SQL Server Agent. Following query gets you SQL Server Agent Account for default instance. You can specify SQLAgent$Instancename if you have named instance installed.



DECLARE @ServiceaccountName varchar(250)
EXECUTE master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE', N'SYSTEM\CurrentControlSet\Services\SQLServeragent',
N'ObjectName',@ServiceAccountName OUTPUT, N'no_output'
SELECT @ServiceAccountName

3 comments: