SQL 2008 enable xp_cmdshell (READ IT PLS)

Hi Folks,

I need help please. I am receiving this message when I try and run this under SQL 2008
EXEC util_ObjOut 'util_objout', 'p', 'C:\temp'

Before you well meaning experts tell me its as simple as this--
   EXEC sp_configure 'show advanced options', 1
   GO
   RECONFIGURE
   GO
   EXEC sp_configure 'xp_cmdshell', 1
   GO
   RECONFIGURE
   GO

Please know I have already run it with the following results:  
   Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
   Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.

Opening SQL Server Management Studio, right clicking on the server and selecting facets, then selecting "Server Configuration" in the Facet dropdown reveals XPCmdShellEnabled is set to TRUE, yet I receive the same error.

THANK YOU SO MUCH, I have to get this fixed.
LVL 2
Trish BenningfieldTECHGRLAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kyle AbrahamsSenior .Net DeveloperCommented:
try
"reconfigure with override"  instead of just reconfigure.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Trish BenningfieldTECHGRLAuthor Commented:
Thanks, will try that.

FYI, I was trying to post the actual error (I forgot to include) , and it was MSG 50000, LEVEL 16, STATE 1, procedure util_ObjOut, LIne 267
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....
0
Trish BenningfieldTECHGRLAuthor Commented:
THANKS, doesn't work.....

RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO

Shows it change from 1 to 1....

Same error when I run the EXEC util_ObjOut 'util_objout', 'p', 'C:\temp' command.
0
Kyle AbrahamsSenior .Net DeveloperCommented:
does the file you're trying to execute have permissions?  Can you check by adding "everyone" for read and execute?  Does it work with any batch file or not at all?

What permissions does the user who you're trying to execute this as have?

Also just as another check if you grant them SA for now will it work?
0
Trish BenningfieldTECHGRLAuthor Commented:
I am the administrator, I have confirmed the sysadmin privilege.

OK, so here is what I did-- I ran each line separately one at a time, and voila.  

Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.