SQLBrowser Account

• mtz676

  SSCrazy Eights

  Points: 9176

  More actions

  February 1, 2016 at 10:11 am

  #399656

  How do I get to know under which account SQLBrowser is running using a sql query?

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  February 1, 2016 at 10:34 am

  #1855751

  sys.dm_server_services wont include Browser service...

  So, you can use old school technique of pulling it from registry. Below query should do it...

  DECLARE @DBEngineLogin VARCHAR(100)

  DECLARE @AgentLogin VARCHAR(100)

  DECLARE @Browserlogin VARCHAR(100)

  EXECUTE master.dbo.xp_instance_regread

  @rootkey = N'HKEY_LOCAL_MACHINE',

  @key = N'SYSTEM\CurrentControlSet\Services\MSSQLServer',

  @value_name = N'ObjectName',

  @value = @DBEngineLogin OUTPUT

  EXECUTE master.dbo.xp_instance_regread

  @rootkey = N'HKEY_LOCAL_MACHINE',

  @key = N'SYSTEM\CurrentControlSet\Services\SQLServerAgent',

  @value_name = N'ObjectName',

  @value = @AgentLogin OUTPUT

  EXECUTE master.dbo.xp_instance_regread

  @rootkey = N'HKEY_LOCAL_MACHINE',

  @key = N'SYSTEM\CurrentControlSet\Services\SQLBrowser',

  @value_name = N'ObjectName',

  @value = @BrowserLogin OUTPUT

  SELECT [DBEngineLogin] = @DBEngineLogin, [AgentLogin] = @AgentLogin,[browserlogin] =@BrowserLogin

  GO