Key point - remember to log into the SQL Server box using the NT login account that has been assigned to SQLServerAgent.
-Mike
>Mike
>
>>Trying to setup SQLMail using SQL Server Agent properties window. In the mail session box it's asking for mail profile using a pull-down dialog box, which is empty. I've setup several mail profiles, but they do not show in this box! What steps am I missing?
>
>Make sure you are starting the SQL Server Agent Service using an specified account (rather than system account) which has access to the exchange server. Next, in exchange (on the SQL Box) add the Microsoft Exchange Server service, with the required Exchange server name, and the mailbox for the account you are starting SQL Server Agent with.
>
>Then in the SQL Server Agent, change the Mail Profile to MS Exchange Settings.
>
>Stop and Restart SQL Server agent and all should be well.
>
>Cheers
>Steve Lea