Scripts from SQL Domian Accounts

• Arjun SreeVastsva

  SSCertifiable

  Points: 7137

  More actions

  October 5, 2012 at 1:38 am

  #263418

  hi,

  i need sql script which will give the domain account services accounts should be used.

  Thanks

  Arjun

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  October 8, 2012 at 8:08 am

  #1546745

  Hi ,

  Try to use the below script

  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

  Regards,
  Kumar