Agent XP nowhere to be found?

• wreiman 78397

  Old Hand

  Points: 334

  More actions

  October 3, 2017 at 12:15 pm

  #350199

  So I'm setting up a new server with a fresh copy of SQL Server 2008r2 and Ive gotten to the point of setting up the Agent XPs  so I can turn on the Server Agent.
  So I run :
  sp_configure 'show advanced options', 1;
  GO
  RECONFIGURE;
  GO
  sp_configure 'Agent XPs', 1;
  GO
  and get (The configuration option 'Agent XPs' does not exist, or it may be an advanced option.).

  So I take a look and guess what... it's not there.

  I've google'd this a few times... am getting nothing. Any clues?

• wreiman 78397

  Old Hand

  Points: 334

  More actions

  October 3, 2017 at 12:53 pm

  #1962132

  Never mind... I was having a 'Blond Moment'..... figured it out.

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  October 3, 2017 at 5:04 pm

  #1962189

  Care to share for other blondes out there?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 3, 2017 at 5:39 pm

  #1962191

  Joe Torre - Tuesday, October 3, 2017 5:04 PM

  Care to share for other blondes out there?

  Would have probably just highlighted and ran the sp_configure 'Agent XPs', 1;
  That screenshot would be with allow advanced options set to 0

  Sue