xp_cmdshell disabled after reboot

• Road Kill

  SSCrazy

  Points: 2135

  More actions

  October 15, 2010 at 8:43 am

  #230523

  I have a SQL Server 2008 STD server that has xp_cmdshell enabled for a vendor process. Whenever the server reboots, xp_cmdshell gets disabled. See below for messages in SQL Error Log.

  10/13/2010 03:11:41 Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.

  10/13/2010 03:11:41 Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.

  10/13/2010 03:11:41 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'STANDBY'.

  10/13/2010 03:11:41 Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.

  10/13/2010 03:11:41 Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.

  10/13/2010 03:11:41 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'STANDBY'.

  10/13/2010 03:11:41 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'STANDBY'.

  10/13/2010 03:11:41 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

  10/13/2010 03:11:41 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

  The server rebooted due to Windows Updates. For some reason, SQL Server wants to enabled it and then disable it. How do I get it to stay enabled after reboot? I enabled xp_cmdshell in the past using Surface Area Configuration and running sp_configure/reconfigure.

• sturner

  SSC-Insane

  Points: 22411

  More actions

  October 15, 2010 at 9:06 am

  #1237627

  With 2008 you do it with "facets". Right click on the server instance in the SSMC and select facets......

  The probability of survival is inversely proportional to the angle of arrival.

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  October 15, 2010 at 9:51 am

  #1237653

  sp_configure will still work, it will be interesting to see what is disabling it, are there any startup stored procedures?

  Hope this helps,
  Rich

  [p]
  [/p]

• Road Kill

  SSCrazy

  Points: 2135

  More actions

  October 15, 2010 at 11:47 am

  #1237749

  That's it! I had a start up procedure that enabled xp_cmdshell, ran some scripts, and then disabled it. I removed the disable statement.

  Thank you!