Information générale
Forum:
Microsoft SQL Server
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement