November 10, 2004 at 10:15 am
I have been trying to setup SQL Mail forever and it just won't work. Is anyone willing to help me out with this?
When I setup a notification of a job and try to send a test email from it, it gives me this error:
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.
When I right click on SQL Server Agent --> Properties, I have tried to set it to an account I made of SQLAdmin. Is that what I am supposed to do? It won't accept it though. I also logged on to the server under that account, which I read I am supposed to do.
Anyway, please help me! I need it
Brenda
November 10, 2004 at 10:24 am
I'd start with this article: http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp
and then look through some of the discussion forums on this site. very helpful info. don't forget that the mail profile needs to be set before you configure agent mail. meaning you need to be able to send and receive email via outlook before proceeding. then setup the user account for sql agent to match that mail profile.
November 10, 2004 at 10:28 am
I have gone through all of those articles. I have setup Outlook also. When is use the QA and do this:
exec master..xp_sendmail @recipients='brenda@capitaltracer.com', @subject='Mail Test'
It works, but setting up notificationss and stuff doesn't work.
Any other suggestions? Thanks!
November 10, 2004 at 10:39 am
OK,
you have SQL Mail working. one of two mail options (of course not the one that works with job alerts which is what you want)
Under SQL Server Agent Properties, under the General Tab have you specified the account the service uses to run? this should match the domain account that the mail is configured for.
you should then see by the mail session/mail profile the words: MS Exchange Settings.
bare with me here...have you checked that yet?
November 10, 2004 at 10:58 am
Ok, I have done all of that now. I have set up my SQLAdmin account on both MSSQLSERVER and SQLSERVERAGENT. Also, the mail profile is setup. When I try to run a test email on a job, it won't work. It still says
November 10, 2004 at 12:40 pm
So does anyone out there have any ideas about what would be going wrong?
I think it has something to do with MAPI.
Thanks!
November 11, 2004 at 2:10 am
If you to setup an operator, can you test email by clicking test.
November 11, 2004 at 2:18 am
Try this page, it may help you
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B315886
November 11, 2004 at 6:28 am
when you set up the operator and send a test message, what happens?
November 11, 2004 at 7:33 am
You've stopped and restarted the SQL Server?
John Scarborough
MCDBA, MCSA
November 11, 2004 at 9:25 am
Yes, I have stopped and started MSSQLSERVER and SQLSERVERAGENT.
When I try to run a test email on an operator, it says:
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.
The mail profile that is set up is SQLAdmin. What does it mean by the mail seesion?
Thanks for your help!
Brenda
November 11, 2004 at 1:13 pm
Expand enterprise manager for the server in question. Right click on SQL Server Agent node, select Proerties. What is the profile selected for mail session?
November 11, 2004 at 1:16 pm
Oops, missed a step. Expand management after expanding the server.
What happens when you click the test button there too?
November 11, 2004 at 1:19 pm
SQLAdmin is and when I click test, it works. Why won't it work when I try to do a test email for a job?
November 11, 2004 at 1:51 pm
When I just open up Properties on the SQLAdmin operator, it won't let me send an email. It is still saying the same thing. I have been reading different things and just can't figure it out. Anyone out there willing to help me out some more? Thanks!
Brenda
Viewing 15 posts - 1 through 15 (of 40 total)
You must be logged in to reply to this topic. Login to reply