db mail - Relay access denied on (can't sent to external address) same smtp setting working on another server

Question

db mail - Relay access denied on (can't sent to external address) same smtp setting working on another server

ebooklub

Hall of Fame

Points: 3905
More actions
December 7, 2018 at 8:06 am

#369356

I am doing remote dba for client and setting email alerts
client has 2 sql servers on same domain installed on different boxes
Server 1 sql 2014
db mail set to use stmp with anonymous login
I can set emails to address outside domain
Server 2 sql 2005 (yes I know....)
db mail set to use same setting as Server 1 (same Smtp with anonymous login)
when I try to sent test mail from server 2 I get error
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-12-07T08:07:47). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 <dba01@mydomain01.com>: Relay access denied).
)
1. I don't have access to Exchange
2. I don' t have emails with internal domain address (asking users to reply to see if they get email)
3.I have local admin access on Server 1 and Server 2 using RDP
I am not an expert in Exchange, from what I see
2 NT boxes on same domain using same mail account ,one can sent email another not
Could it be that sending external email restricted from partial IP ?
How to verify it?
Thank you

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

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

ebooklub - Friday, December 7, 2018 8:06 AM
I am doing remote dba for client and setting email alerts
client has 2 sql servers on same domain installed on different boxes
Server 1 sql 2014
db mail set to use stmp with anonymous login
I can set emails to address outside domain
Server 2 sql 2005 (yes I know....)
db mail set to use same setting as Server 1 (same Smtp with anonymous login)
when I try to sent test mail from server 2 I get error
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-12-07T08:07:47). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 <dba01@mydomain01.com>: Relay access denied).
)
1. I don't have access to Exchange
2. I don' t have emails with internal domain address (asking users to reply to see if they get email)
3.I have local admin access on Server 1 and Server 2 using RDP
I am not an expert in Exchange, from what I see
2 NT boxes on same domain using same mail account ,one can sent email another not
Could it be that sending external email restricted from partial IP ?
How to verify it?
Thank you

Speak to your Exchange admin and ask them to allow external e-mails to be sent from Server2.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

ebooklub Hall of Fame Points: 3905 More actions · Answer 2

"Speak to your Exchange admin and ask them to allow external e-mails to be sent from Server2."

So External email could be restricted to particular IP?

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

ebooklub - Friday, December 7, 2018 8:19 AM
"Speak to your Exchange admin and ask them to allow external e-mails to be sent from Server2."
So External email could be restricted to particular IP?

It is restricted based on origin. I don't know whether it's done by IP address or by server name.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

Phil Parkin - Friday, December 7, 2018 8:23 AM
ebooklub - Friday, December 7, 2018 8:19 AM
"Speak to your Exchange admin and ask them to allow external e-mails to be sent from Server2."
So External email could be restricted to particular IP?
It is restricted based on origin. I don't know whether it's done by IP address or by server name.

Anonymous SMTP relay is a security concern. So it might need to be justified as to WHY you want it .:)

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?