October 30, 2009 at 1:13 pm
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?
November 2, 2009 at 2:28 am
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/
November 2, 2009 at 5:38 am
Thank you very much for the response.
November 3, 2009 at 2:37 am
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