Hi. I'm trying to configure sql mail and agent on my sql 2000 server but I'm having a problem. Here are the steps that I have taken.
Created a domain account.
Created a mail box on exchange 5.5 server.
Created a profile for the domain account using domain account login on the server.
I'm able to send emails using this profile.
Assigned the profile name to sql mail with the domain account log on and test ok.
Assigned the profile name to sql agent with the domain account log on and test ok.
Started the services.
It errors out while trying to send an email using an operator. The error message is Error 22022: SQLServerAgenct Error: The SQLServerAgent mail session is not running; ...
Any help is appreciated.