DB Mail

Question

DB Mail

bala2

SSCertifiable

Points: 5547
More actions
February 21, 2012 at 3:56 am

#391604

I have configured the db mail in sql server 2008 r2.Am getting the below error when i was testing the dbmail.
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-02-21T10:46:35). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 66.54.36.34:25)."
can any one help me about the error.

Viewing 11 posts - 1 through 10 (of 10 total)

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

Ant-Green SSC Guru Points: 113504 More actions · Answer 1

seems like the smtp server is not accepting your IP as an SMTP client.

are you using Exchange? has the servers IP been granted the nessesary access on the SMTP server, if it is exchange it needs to be in two places in the SMTP configuration.

what anti virus do you use as well as a side note.

Violeta-310146 Mr or Mrs. 500 Points: 539 More actions · Answer 2

Did you enable Dazabase Mail? It is disabled by default....

sp_CONFIGURE 'show advanced', 1

GO

RECONFIGURE

GO

sp_CONFIGURE 'Database Mail XPs', 1

GO

RECONFIGURE

GO

Loundy SSCertifiable Points: 6080 More actions · Answer 3

I believe you also need to enable mail session in sql agent

Don't think this will be causing your error though - just thought i'd point it out 🙂

[font="Times New Roman"]There's no kill switch on awesome![/font]

Ant-Green SSC Guru Points: 113504 More actions · Answer 4

Loundy (2/21/2012)
I believe you also need to enable mail session in sql agent
Don't think this will be causing your error though - just thought i'd point it out 🙂

this is only if you want to send alerts to operators which go through the agent.

you dont need to do this if you are manually executing sp_send_dbmail

bala2 SSCertifiable Points: 5547 More actions · Answer 5

i have checked and "mail session " in sqlagent is in enabled state.

Ant-Green SSC Guru Points: 113504 More actions · Answer 6

anthony.green (2/21/2012)
seems like the smtp server is not accepting your IP as an SMTP client.
are you using Exchange? has the servers IP been granted the nessesary access on the SMTP server, if it is exchange it needs to be in two places in the SMTP configuration.
what anti virus do you use as well as a side note.

vijay

what diagnostics have you done?

have you checked SMTP server is allowing your SQL server to send mail?

have you checked that there are no firewall restrictions?

have you checked that any antivirus software is not blocking mass mail worms?

have you checked any authentication settings?

bala2 SSCertifiable Points: 5547 More actions · Answer 7

Can you please tell me how to check the above diagnostics things .

Ant-Green SSC Guru Points: 113504 More actions · Answer 8

have you checked SMTP server is allowing your SQL server to send mail - speak to your email administrator, if using MS Exchange, SMTP Mail Relay requires the IP of the server to be placed in two different locations to send mail

have you checked that there are no firewall restrictions - speak to your network administrator, advise to check windows firewall on SQL and SMTP server as well as corporate firewall

have you checked that any antivirus software is not blocking mass mail worms - speak to your AntiVirus administrator, they should be able to advise. If using McAfee use EPO to disable mass mail worm for your SQL server otherwise the policy will re-enable it

have you checked any authentication settings - speak to your email administrator and ask if SMTP needs authentication or if it is annoymous authentication. check your database mail profile is using the right authentication settings

bala2 SSCertifiable Points: 5547 More actions · Answer 9

when telnet smtpserver ie. telnet <smtpserver name > 25

am getting below error

" could not open connection to the host on port 25:connect failed "

Ant-Green SSC Guru Points: 113504 More actions · Answer 10

vijay82 (2/21/2012)
when telnet smtpserver am getting as could not open connection to the host on port 25:connect failed

anthony.green (2/21/2012)
seems like the smtp server is not accepting your IP as an SMTP client.
are you using Exchange? has the servers IP been granted the nessesary access on the SMTP server, if it is exchange it needs to be in two places in the SMTP configuration.

lets go back to my original post then ^^^