SQL Agent account in DMV?

• Johnathon Wilde

  Mr or Mrs. 500

  Points: 544

  More actions

  July 2, 2010 at 10:46 am

  #222797

  Does anyone know if there's either a system table or DMV that you can run that shows you the basic configuration information for a SQL Instance? I'm mainly trying to find out the name of the account that SQL and SQL Agent, etc., are running under by just executing a script.

• Jason Messersmith

  SSC Eights!

  Points: 874

  More actions

  July 2, 2010 at 1:24 pm

  #1188400

  select * from sys.configurations

  Are you looking for the account running the SQL and SQL Agent Service?

• Jason Messersmith

  SSC Eights!

  Points: 874

  More actions

  July 2, 2010 at 1:28 pm

  #1188401

  DECLARE @serviceaccount varchar(100)

  EXECUTE master.dbo.xp_instance_regread

  N'HKEY_LOCAL_MACHINE',

  N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

  N'ObjectName',

  @ServiceAccount OUTPUT,

  N'no_output'

  SELECT @Serviceaccount

• Johnathon Wilde

  Mr or Mrs. 500

  Points: 544

  More actions

  July 2, 2010 at 2:14 pm

  #1188425

  Yeah, that last script was exactly what I was looking for! Thanks, Jason! I appreciate it!