Database mail

Question

Database mail

Manie Verster

SSCertifiable

Points: 7152
More actions
July 9, 2008 at 1:07 am

#129817

Hi guys,
I need some help please! I setup alerts on SQL Server 2005 Studio Manager so an e-mail be sent to me when errors occurs buta alas! no joy. I keep on getting the following error message in the logs:
Message [264] An attempt was made to send an email when no email session has been established
I set alerts on all my maintenance plans as follows:
1. General: Selected severity - 007 Nontification: Status Information
2. Response: Checked Notify Operators and checked E-Mail next to the operators name.
3. Options: Checked E-Mail
The way I set my database mail is as follows:
E-mail address, servername and the port is 25. I used anonymous authentication. When I sent a test e-mail it worked but whenever a e-mail has to be sent from an alert I get the above message.
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

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

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

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 1

[font="Verdana"]Hi,

Do you have a public mail profile & default mail profile?? If not provide public privilege to the profile you have created and make it as default profile [/font]

Regards..Vidhya Sagar
SQL-Articles

Manie Verster SSCertifiable Points: 7152 More actions · Answer 2

Thanks for the help. I'll check it but it should be correct. Thanks

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)

Todd Engen SSCrazy Eights Points: 9869 More actions · Answer 3

Manie,

Another thing you might want to check is the Alert System settings, which is a property of the SQL Agent. See if a Enable mail profile is enabled.

sqlservercenter-793614 SSC-Addicted Points: 463 More actions · Answer 4

Have you setup right SMTP in the DB mail profile?

And ,after setup that, you could take a test.

[font="Arial"]MCDBA, MCITP (DB Dev, DB Admin), MCSE,MCTS, OCA 10g[/font]

Manie Verster SSCertifiable Points: 7152 More actions · Answer 5

sqlservercenter (7/10/2008)
Have you setup right SMTP in the DB mail profile?
And ,after setup that, you could take a test.

Manie,
Another thing you might want to check is the Alert System settings, which is a property of the SQL Agent. See if a Enable mail profile is enabled.

Yes, I have setup the SMTP right and I did test it and it worked and yes, Enable mail profile is enabled. Thanks for your replies but that is not the problem. You see, after adding the alert on the database, it gives you the option to test the e-mail and it worked but for some reason it can't createa session to send e-mails from the database.

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)