Saturday, January 8, 2011

SQL SERVER 2008 – Enable xp_cmdshell


---- To allow advanced options to be changed.
EXEC sp_configure ‘show advanced options’, 1
GO
—- To update the currently configured value for advanced options.
RECONFIGURE
GO
—- To enable the feature.
EXEC sp_configure ‘xp_cmdshell’, 1
GO
—- To update the currently configured value for this feature.
RECONFIGURE
GO

 
Alternative way

1. Click the Start button.
2. Select All Programs.
3. Navigate to the Microsoft SQL Server 2008 folder.
4. Right Click on Server name then click facets options
5. In the Facets Option choose Surface Area Configuration in dropdown
6. At the bottom of the window, mark True for xp_cmdshell.
7. Click OK.

Posted by Varinder Sandhu at 8:55 PM
Labels:

6 comments:

  1. AjayJanuary 10, 2011 at 4:49 AM

    i have tried the alternative way and it worked for me.

    thanks
    Ajay

    ReplyDelete
  2. AmanJanuary 11, 2011 at 1:37 AM

    it really help.

    ReplyDelete
  3. AnonymousDecember 14, 2011 at 9:34 PM

    Thanks for the Alternative way
    SRK

    ReplyDelete
  4. Byron BranfieldJuly 30, 2012 at 10:26 PM

    I must just sa, I was struggling with this for a while and nothing worked. Your alternative way did the job, thank you very much.

    ReplyDelete
  5. AnonymousMarch 13, 2013 at 7:15 AM

    ty so so much

    ReplyDelete
  6. AnonymousJune 19, 2013 at 7:00 AM

    For SQL Server 2008 R2 you can go into SSMS, right click on the server, select Facets. In the new window that comes up change the Facet to Surface Area Configuration and you'll find XPCmdShellEnabled in the Facet properties below.

    ReplyDelete

Subscribe to: Post Comments (Atom)