SQL Notification

[Rock2447]

I'm trying to set up an operator in my SQL Server Agent. I installed Outlook 2000 and then tried to configure a new operator and when I put my test email address or any email address I get a message saying to configure the SQLServerAgent mail session is not running; check the mail and/or the SQLServerAgent service Startup account in the SQLServerAgent Properties dialog. What do I need to do?

 

[ecobb]

Look under "Services" on the Server. There is a listing for SQLSERVERAGENT. Make sure the status is "Started" and the startup type is "Automatic". If it's not, highlight it and tell it to start. Then go to the properties and change the startup type to "Automatic".

Hope this helps.

 

[SeaninSeattle]

You also need to go into SQLMail and ensure that you have the MAPI profile name in there - not the account name that SQLMail will use. This drove me crazy for a long time until I figured out what they were asking for...

If the profile (in Outlook for the local MAPI client - right click on the Outlook icon on the desktop, then properties, then 'profiles') is using 'MS Exchange Settings' then that's what you have to use in the SQL Mail settings. If you renamed it to something else, then that's what you have to use.

Once you have the settings correct (including the logon authority for SQLMail), then you should be able to start and run the service without any issue.

//sse

Sean Engle
Admin/DirIS
ssengle@bswusa.com