i have set up database mail on a sql 2005 server, the same way as other servers. but on this server all mail are queued and in unsent status. In SQL error log, there are lots of entries on "The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The EXECUTE permission was denied on the object 'xp_sysmail_activate', database 'mssqlsystemresource', schema 'sys'.'
I tried to grant exec permission to sql agent service account, restart database mail, restart sql server agent, restart sql server but none of them work.
I have verified: broker service started on msdb and database mail is started.
Any insight?