Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

trying to enable xp_cmdshell on sql 2000 Expand / Collapse
Author
Message
Posted Friday, October 30, 2009 1:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 6:57 PM
Points: 148, Visits: 640
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?
Post #811824
Posted Monday, November 2, 2009 2:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 12:43 PM
Points: 2,109, Visits: 5,419
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/
Post #812247
Posted Monday, November 2, 2009 5:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 13, 2014 6:57 PM
Points: 148, Visits: 640
Thank you very much for the response.
Post #812323
Posted Tuesday, November 3, 2009 2:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:55 AM
Points: 2,868, Visits: 3,214
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #812803
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse