I guess one is likely to encounter this error if upgrading from SQL Mail to Database Mail. I guess that's what you stumbled into here.
Please note that you will also need that Service Broker is enabled.
However, the bigger problem I feel is that you are moving ahead without a checklist and a plan! Checking the environment before execution is one of the basic steps when dealing with configuration change. Otherwise, you might end up loosing track of what changed and what did not.
commented on Oct 8 2011 8:44AM