September 5, 2007 at 7:37 am
Howdy
I have seen quite a few posts on Database Mail but was unable to find a solution. Hopefully someone knows the answer to my problem.
Problem:
Database Mail sends mail to users inside the domain but does not deliver to users outside the domain.
Database Mail Log Error Message:
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-09-05T09:02:38). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for YourMom@hotmail.com)
Attempts:
I have tried all 3 options of SMTP Authentication available in the Database Mail Configuration Wizard.
I read that antivirus may block port 25; but I do not know how to check ports or even if I should be checking a port on SQL or SMTP server.
Any help would be fantastic.
Thanks
September 5, 2007 at 8:07 am
That's not a SQL issue per se - that's purely an e-mail configuration. SQL relies on the e-mail profile you picked to be set up "right". It's just passing back the info it's getting from the e-mail client.
You probably want to fight this perticular battle outside of SQL server. Get the server to be able to send e-mail out correctly on its own (as if it were a "regular" workstation). Once you do get the config to work right, SQL's hook to that configuration will work.
----------------------------------------------------------------------------------
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?
September 5, 2007 at 8:23 am
Hi
So you are saying that the particular email account I am using is unable to send outside the domain?
I just ran a test, put in my email address and still recieved the same error.
I also don't have office on that server, how can I get the server "to send e-mail out correctly on it's own?"
September 5, 2007 at 9:47 am
Not so much the account per se - it's in the e-mail configuration. It wouldn't matter what application it was - the message implies the config itself isn't quite right.
Try taking a look at whether your SMTP server requires you to log in first before being allowed to send stuff out.
I hear you about not having that installed on the server. I just find it a whole lot easier to hammer out what the config SHOULD be in a stand-alone program (like - outlook express, etc). They'll give you easier fairly obvious messages, it's easy to test, etc.... Whether it's worth installing is obviously your call.
----------------------------------------------------------------------------------
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?
September 5, 2007 at 9:45 pm
You need to talk to the admins of your SMTP server, the error message you are receiving "Mailbox unavailable. The server response was: 5.7.1 Unable to relay for YourMom@hotmail.com" is a relay denial. Depending on how your SMTP server it set up it might be as simple as having the IP address of your SQL server added to the list of hosts that are allowed to send/relay mail. You as an individual may have the right to relay (e.g. send mail outside the organization) but the SMTP server may be set to allow server to server connections from only specific hosts/subnets.
Joe
September 6, 2007 at 10:10 am
It sounds like they have restricted access to your SMTP server by IP only. You need to have the IP address of your SQL Server added to the 'allow' portion in order for the SMTP forwarding you need to occur. Contact either your Exchange or Domain Admin for the needed update/
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply