Find the Account under which SQL Server runs

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  March 10, 2011 at 3:29 pm

  #389025

  Hi,

  Is there a query to find the Account under which SQL Server/Agent runs.I can do it manually by looking at the services or right clicking the server/agent, but if tis information is needed over a number of sql servers, then this becomes cumbersome. So, is there a way to do this?

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 10, 2011 at 4:14 pm

  #1297399

  You can do this with sc.exe:

  C:\>sc qc SERVICE_NAME

  http://technet.microsoft.com/en-us/library/bb490995.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato