I'm having a heck of a time getting SQL email working. I have went through the following steps:
1. Create DB mail account: http://technet.microsoft.com/en-us/library/ms190658.aspx
2. Create DB mail profile: http://technet.microsoft.com/en-us/library/ms187605.aspx
And here is where I get stuck: http://msdn.microsoft.com/en-us/library/ms186358.aspx
When I go to the DatabaseMailUserRole in the msdb database and try and add my domain account that the sql server agent runs under, it will not allow me to do so. It says it cannot find the account.
I know I must be missing something fairly simple, but need your help.