trying to enable xp_cmdshell on sql 2000

  • Trying to enable xp_cmdshell on sql 2000, but getting the following error: "

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

    Trying to run the following

    -- 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

    -- I get the error after I run the above stmt.

    -- To update the currently configured value for this feature.

    RECONFIGURE

    GO

    I checked the version: 8.00.2039

    Anyone have any ideas?

  • The option to enable or disable xp_cmdshell with sp_configure was intreduced only SQL Server 2005. With SQL Server 2000 this extended stored procedure is always enabled.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Thank you very much for the response.

  • If you want someone without sysadmin rights to use xp_cmdshell in SQL 2000, you need to set up a proxy account.

    Books Online (BOL) gives good details on how to do this. Except that BOL does not tell you that if you use a long password for the proxy it will be truncated at 15 characters. This restriction has been removed for SQL 2005 and above.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

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