TomThomson (10/24/2016)

---

Jeff Moden (10/23/2016)

---

The correct answer is only a 1/4 correct. You also have to enable advanced options and RECONFIGURE twice (once for the advanced options and once to enable xp_CmdShell.

Heh... of course, the way I look at it, you shouldn't have to enable it. It should already be enabled because there's no security advantage to disabling it. 😉

Actually it's really only 1/6 correct, because you might want to disable advanced options and reconfigure again.

I agree that it's been pretty pointless having it disabled as default since the holes in the proxy handling were fixed maybe 14 years ago (I can't remember which service pack fixed that, but I know is it was later than 2002 and earlier than 2005).