Post reply

Unable to enable xp_cmdshell on SQL 2000

  • January 26, 2010 at 1:33 pm

    #94418

    This should be a simple task to do in 2000 but here is what was run in Query Analyzer:

    EXEC sp_configure 'show advanced options', 1

    GO

    RECONFIGURE

    GO

    EXEC sp_configure 'xp_cmdshell',1

    GO

    RECONFIGURE

    GO

    When trying to run exec sp_configure 'xp_cmdshell', 1 I get the following error:

    The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

    Valid configuration options are: (none were provided)

    I tried RECONFIGURE WITH OVERRIDE and that did nothing to change it.

    Any positive feedback will be greatly appreciated.

  • January 26, 2010 at 2:23 pm

    #1108954

    have a look at the following. While it doesn't exactly answer your question, it should point you in the direction of where to start looking for how it was disabled on your system...

    http://www.sqlservercentral.com/Forums/Topic426147-5-1.aspx

    See EdVassie's comments towards the bottom...

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply