How do I enable "XP_cmdshell" feature for Microsoft SQL Server?

Topic

  • How do I enable "XP_cmdshell" feature for Microsoft SQL Server?

Environment

  • Product Family: Software
  • Product: Microsoft SQL Server 2005, 2008, 2014
  • Component:
  • Control System: Microsoft SQL Server Management Studio 2005, 2008, 2014

Steps

How to enable XP_cmdshell feature for SQL Server 2005:

    1. Navigate to Windows Start Menu -> Microsoft SQL Server 2005 -> Configuration Tools and then click on "SQL Server 2005 Surface Area Configuration."
    2. Select "Surface Area Configuration for Features."
    3. From the left panel, select "xp_cmdshell."
    4. Place a check next to "Enable xp_cmdshell."
    5. Click "Apply" and then "Ok."

How to enable XP_cmdshell feature for SQL Server 2008:

    1. Navigate to Windows Start Menu -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Management Studio 2008.
      1. Install Microsoft SQL Server Management Studio 2008 if it is not already installed: How to download and install Microsoft SQL Server Management Studio 2008 for SQL Server 2008
    2. Once access to SQL Server Management Studio 2008 is present, right click on "[COMPUTER NAME]\NUCLEUS" in the Object Explorer on the left panel and then click "Facets."
    3. In the View Facets window, click on the Facet drop down menu and select "Surface Area Configuration."
    4. Locate "XPCmdShellEnabled" and then click on the drop down menu to the right and select "True."
    5. Click "Ok" to accept changes.

How to enable XP_cmdshell feature for SQL Server 2014:

    1. Install Microsoft SQL Server Management Studio 2014 if it is not already installed: How do I download and install Microsoft SQL Server Management Studio 2014 for SQL Server 2014?
    2. Navigate to Windows Start Menu -> Microsoft SQL Server 2014 -> Configuration Tools -> SQL Server Management Studio 2014.
    3. When the first prompt comes up, select "Connect" to establish a connection to the Nucleus service.
    4. Right click on "[COMPUTER NAME]\NUCLEUS" in the Object Explorer on the left panel and select "Facets."
      FACETS_js.jpg
    5. In the View Facets window, click on the "Facet:" drop down window and select "Surface Area Configuration."
    6. In the "Facet Properties:" section of the window, find "XPCmdShellEnabled," click on the drop down window to the right and select "True" from the list of options.
    7. Click "OK." XPCmdShell should now be enabled.
      • If you receive an error at this step, please contact Daktronics Help Desk.

KB ID: DD3360274


Fill out my online form.

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.