January 27, 2009 at 2:14 am
Hi Guys
I am new to SQL and having some issues with XP_Cmdshell. I have SQLEXPRESS 2005 installed on a Windows 2003 Server (Domain controller). Server has been logged on using Administrator account and SQLEXPRESS logged on with Windows authentication.
I have written a fair bit of SQL Sp's using XP_cmdshell. All these SP's are working perfectly fine on my XP development system, but I cannot execute this on Windows 2003 Server box. I cannot even enable the XP_Cmdshell using "SQL Server Surface Area Configuration" and get an error like "light weight pooling is not allowed on this platform". I tried enabling through SQL script, that did not work either.
I need a solution to make the XP_cmdshell working without an alternative to XP_cmdshell.
Can someone please help me.....
February 2, 2009 at 5:46 am
I've heard of some issues with 64bit server editions and XP_cmdshell... Dunno if that's the case, but...;)
February 2, 2009 at 7:49 am
I may have found the reason for your problem because xp_cmdshell can be used to do many things which Microsoft may not want you to do so to use it in SQL Server Express which comes without the Agent you need server control permission. When you have the Agent you can run it with Agent proxy account. Check the first link to change your permissions in Windows 2003 or find a SQL Server instance in your network you can use the Agent to run xp_cmdshell with a proxy account.
The second link covers SQL Server configuration options about your error message which says some extended stored procs does not run in that mode.
http://www.developmentnow.com/g/113_2006_5_0_0_762625/xp-cmdshell-in-SQL-2005.htm
http://support.microsoft.com/kb/319942
Kind regards,
Gift Peddie
February 2, 2009 at 1:34 pm
Thank you Gift, I'll try your suggestions....
This has been an ongoing issue for me
Cheers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply