sql mail and sql agent

• peygham

  Say Hey Kid

  Points: 707

  More actions

  October 24, 2005 at 8:25 am

  #169553

  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.

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  October 25, 2005 at 2:05 am

  #599732

  Add:

  Installed Outlook with CDO option (must use Custom install for Outlook and choose to install CDO as CDO is not installed for Typical install).

  Changed SQL Server Agent service account to Domain account.

  Created Operator and tested SQL Server Agent using the Operator Test to send a test email.

  Note, If you plan to use xp_sendmail:

  Change the SQL Server service account to the Domain account.

  Use xp_startmail to start the mail service in SQL Server

  Test SQL Server sending email using xp_sendmail

  Andy