Post reply

XP_CMDSHELL gets disabled upon server reboot

  • December 6, 2011 at 1:06 am

    #253024

    Hi All,

    I am having a little issue. The XP_CMDSHELL gets disabled everytime we reboot our server.

    We have some external processes accessing our db.

    Thanks in advance for helping.

    Ally

  • December 6, 2011 at 1:39 am

    #1417131

    http://www.sqlservercentral.com/Forums/Topic1005254-391-1.aspx

    __________________________
    Allzu viel ist ungesund...

  • December 6, 2011 at 5:09 am

    #1417244

    Thanks for the link.

    However, how would i know the SP's running on server start?

    I checked some of the system sp's but couldn't find any.

    Thanks

    Ally

  • December 16, 2011 at 3:55 pm

    #1422758

    USE master ; --<< important: procs set to start automatically must reside in master

    SELECT *

    FROM sys.procedures

    WHERE is_auto_executed = 1 ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • December 19, 2011 at 5:26 am

    #1423051

    No sp is being auto executed.

    Also I just got the conformation that the server has not been restarted since 2 months.

    So a reboot did not cause the xp_cmdshell to be disabled.

    It is being disabled by another process.

  • December 19, 2011 at 7:27 am

    #1423100

    You may be able to use Policy Management to prevent it from being disabled. Are you on 2008 or higher? Have you used policies before? I know someone who uses policies to prevent xp_cmdshell from being enabled so am confident you could create a policy to enforce that it cannot be disabled, however I have not tried it.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply