xp_cmdshell error

when i run the following in my database server i get following error

1> exec xp_cmdshell 'hostname'
2> go
Msg 11223, Level 17, State 8:
Server 'SYB_UDEPROD15', Procedure 'xp_cmdshell', Line 2:
Insufficient memory is available to allocate structures needed to access a remote site.
(return status = -7)

although i have 2 more ase database servers on the same host, but this runs fine there.

could you please help in this.
LVL 2
Deepak_FILAsked:
Who is Participating?
 
alpmoonConnect With a Mentor Commented:
You can check cis configuration parameters:

sp_configure cis

Compare current values with default values to see whether there is a setting done mistakenly. Otherwise it should work fine with default setting.
0
 
leonstrykerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.