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.
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.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.