trying to enable xp_cmdshell on sql 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » trying to enable xp_cmdshell on sql 2000

trying to enable xp_cmdshell on sql 2000

Rate Topic

Display Mode

Topic Options

Author

Message

tan110

Posted Friday, October 30, 2009 1:13 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 6:54 AM
Points: 146, Visits: 611

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

Adi Cohn-120898

Posted Monday, November 02, 2009 2:28 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 2,018, Visits: 4,915

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

tan110

Posted Monday, November 02, 2009 5:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 6:54 AM
Points: 146, Visits: 611

Thank you very much for the response.

Post #812323

EdVassie

Posted Tuesday, November 03, 2009 2:37 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 2,621, Visits: 2,758

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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 »

Permissions