Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Mail - Error 22022: SQLServerAgent Error Expand / Collapse
Author
Message
Posted Thursday, February 27, 2003 10:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 2, 2004 11:38 AM
Points: 4, Visits: 1
We are trying to implement e-mail notifications when replication fails. When I go into Management > Operators, and add my name from the list of available Exchange addresses, I send a test message which pops up an error stating:

"Error 22022: SQLServerAgent Error: The SQLServerAgent mail session is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent Properties dialog."

Can't seem to find the solution. Ideas?



Post #10271
Posted Thursday, February 27, 2003 1:52 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:43 PM
Points: 1,581, Visits: 6
To be able to use mail you must use a Domain login account for your sql serverices.
Once you have configured that log on into windows with that account and create a mail profile with that account from the control panel and Outlook. then configure SQL.
Also check for more info in the web, because mail setup can be complicated.




Post #55150
Posted Thursday, February 27, 2003 1:56 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:43 PM
Points: 1,581, Visits: 6
If you have everything configured, then check that SQL mail profiles.
From EM, over Support Services, SQL mail, right click, properties.
And SQL Server Agent, properties.




Post #55151
Posted Thursday, February 27, 2003 1:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 2, 2004 11:38 AM
Points: 4, Visits: 1
That did the trick. I had configured the MAPI software in control panel > administrative tools > Mail, but did not set EM to use the right profile. Thanks for the help.




Post #55152
Posted Thursday, February 20, 2014 5:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 12:39 PM
Points: 1, Visits: 1
I see this thread is very old, but am curious as I am having difficulty to set this up. My MAPI profile is set in control panel, when I go to EM, support services, SQL mail, right click properties I can see where to enter a profile, however I have no entries that are available in the drop down.

Does it matter what email service I am using -Exchange, POP3, IMAP?
Post #1543773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse