for SQL 2005 or 08 you need to enable the OLE Automation sps

here is the full query with enable and then disable...