'xp_cmdshell' does not exist??

Question

  Hi to All!

I have two sql server 2008 instances. one is default and the other one is named.

I executed a backup query on the named instance, it worked just fine! but when i executed the same query on the default instance it gave me a error. So i tried to run the piece of code where the error was generated on a separate query. And i got this error;

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

it is the same error that the default server gave me..

What could be the problem?? its running prety gud in the named instance.

Regards,
N_SQL

Answer 1

Dear N_SQL

Please check Surface area configuration<Database Engine>,it is enabled.

---

Thanks & Regards SNIVAS

Answer 2

And how will do that??

sorry for being so dumb!

Answer 3

from this link i found where the surface area configuration is in sql server 2008..

http://www.mssqltips.com/tip.asp?tip=1673 

and then mark "XPCmdShellEnabled" to true.

but still got the same error msg.. :(

Answer 4

Hi

In order to configure xp_cmdshell, first need to enable the advanced options and then only all the advanced configuration options works out.

It can be done as follows:


EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO

Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.

Thanks
Sreekar

Answer 5

Thank You so much it worked :)

opening the link you refered. But it my internet speed is really slow 2day so it is taking too much time..

Can u tell me what dz this code (that u provided) just did??

Answer 6

Hi

There are certain server side configuration options  available which are also known as advanced options. xp_cmdshell is also one of those options.

In order to reconfigure any of these advanced options, first we need to enable show advanced options(set its value to 1). Once this value is set to 1 then only we can able to set the server side configuration options

Thanks
Sreekar

Answer 7

Hi,

 

Using SQL 2008 (not R2)

When tried to enable advance option it works after that when run

 

-- To update the currently configured value for advanced options.
RECONFIGURE
GO

then it gives

Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.

 

after that when i run

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option.

 

Please advice

 

Thanks!!!

---

Varinder Sandhu http://varindersandhus.blogspot.com/

Answer 8

Hi

http://www.mssqltips.com/tip.asp?tip=1673 

and then mark "XPCmdShellEnabled" to true.

 

it worked 

thanks

---

Varinder Sandhu http://varindersandhus.blogspot.com/