November 22, 2006 at 11:44 pm
I am unable to use xp_cmdshell in SQL 2K5 Express Edition despite having enabled it successfully using the SQL Server Surface Area Configuration tool. It gives me the following error: -
==SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.==
Please assist guys.
Thanks.
November 28, 2006 at 11:46 am
Yes there is with a lot risk because you can enable it with sp_configure but it runs with server control permissions so you run it at a lot of risk. When run in an edition with the Agent you run it in the context of the Agent so it runs with proxy account which is cloned permissions meaning limited risk. Check the link below for some options.
http://www.developmentnow.com/g/113_2006_5_0_0_762625/xp-cmdshell-in-SQL-2005.htm
Kind regards,
Gift Peddie
October 21, 2008 at 5:15 am
Are there any workarounds how to run some external tools from MS SQL 2005 express?
October 22, 2008 at 3:02 pm
Yes there is with a lot risk because you can enable it with sp_configure but it runs with server control permissions so you run it at a lot of risk. When run in an edition with the Agent you run it in the context of the Agent so it runs with proxy account which is cloned permissions meaning limited risk. Check the link below for some options. You may want to buy a third party Agent so you don't have to run it direct, some of the reasons it is disabled by default in all editions.
http://www.developmentnow.com/g/113_2006_5_0_0_762625/xp-cmdshell-in-SQL-2005.htm
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply