Discover the Service Account

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Prakash-205770 Ten Centuries Points: 1079 More actions · Answer 1

Try something like this!

DECLARE @account varchar(100)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

N'no_output'

SELECT @account as SQLServer_ServiceAccount

Regards,

Prakash.

Kindest Regards,

R

Jason Crider SSCertifiable Points: 6019 More actions · Answer 2

Thanks, that got me started. Now I can just use the same on SQLServerAgent and I'm good to go.

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 3

Got this from this site I believe way back, this checks to see if it is a named instance and routes the registry accordingly

declare @reg_srv varchar(256),

@reg_agent varchar(256)

if serverproperty('instancename') is null

begin --default instance

set @reg_srv='SYSTEM\CurrentControlSet\SERVICES\MSSQLSERVER'

set @reg_agent='SYSTEM\CurrentControlSet\SERVICES\SQLSERVERAGENT'

end

else

begin --named instance

set @reg_srv='SYSTEM\CurrentControlSet\SERVICES\MSSQL$'+cast (serverproperty('instancename') as sysname)

set @reg_agent='SYSTEM\CurrentControlSet\SERVICES\SQLAgent$'+cast (serverproperty('instancename') as sysname)

end

exec master..xp_regread

'HKEY_LOCAL_MACHINE', @reg_srv, 'ObjectName'

exec master..xp_regread

'HKEY_LOCAL_MACHINE', @reg_agent, 'ObjectName'

go

Andrew