SQL MAIL notification

Question

SQL MAIL notification

Jpotucek

SSCoach

Points: 18583
More actions
July 24, 2007 at 5:33 am

#118002

I have a sql server 2000 sp3a box with 4 named instances.
I have read all of the articles and I cannot get the 'send mail' stuff working.
I have a mailbox associated with the Domanin account that starts the sql server and sql server agent services. I installed Outlook and created a mail profile for this account. I bounced the SQL server agent on one of the Instances but when I go into the properties for the Agent, on the General Tab, the option to choose a mail profile is GREYED out. I tried 'xp_startmail' and I get this error: xp_startmail: failed with mail error 0x80040111
can anyone help???????

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Have you restarted SQL Server services. Just restart both the services. Then try to map the profile to your agent service.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Jpotucek SSCoach Points: 18583 More actions · Answer 2

I restared both services and the option to set a mil profile in the general properties of the agent are still greyed out?

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Ok is the account running the agent service and the id that you are logged in are they same. Jsut try with that i have did it that way and have succedded.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Jpotucek SSCoach Points: 18583 More actions · Answer 4

Thank you so much!!! I logged onto my server with the Domain account that starts the services and created my outlok profile that way. and it WORKS!!!!

EdVassie SSC Guru Points: 60472 More actions · Answer 5

Glad it works! The main thing with SQL mail is that the mail profile must be created using the same account that is used to run the SQL service.

Also, SQL only supports a single SQL mail interface for all instances on the server. This means that if you use different service accounts for each instance, only 1 instance can use SQL mail. If you use the same service account for all instances, then all instances can use SQL mail.

If you find SQL mail ever stops working. (e.g. Exchange is down when you start SQL, or any of the many other reasons SQL mail stops) then you normally need to visit each instance to get SQL mail working again for that instance. After a while, you will get a LOT of experience in troubleshooting SQL mail.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara