Post reply

cannot enable xp_cmdshell in sql server2005

  • February 16, 2011 at 6:32 am

    #233784

    I have tried running the following when I'm on sql server 2005?:

    USE master

    GO

    EXEC sp_configure 'show advanced options', 1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    EXEC sp_configure 'xp_cmdshell', 1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    EXEC sp_configure 'show advanced options', 0

    GO

    but I keep getting an error:

    "The configuration option 'xp_cmdshell' does not exist, or it may be an advanced option."

    Any idea why I'm getting this?

  • February 16, 2011 at 6:50 am

    #1287619

    Can you provide the sql version please?

    select serverproperty('ProductVersion')

    This advanced setting is only available in 2005 and above.

    My only other thought is running each sql statement individually and confirming success as I've ran the exact same code on my local instance and it works fine.

  • February 16, 2011 at 7:39 am

    #1287679

    Thanks.

    It's a 2000 DB so that explains things. I was looking in Help>About in Management Studio to find the version and that is 2005.

Viewing 3 posts - 1 through 2 (of 2 total)

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