January 10, 2011 at 8:45 am
I'm testing how to setup database mail from SQL server management studio 2005. For now, I want to use my own email address for the profile.
I finished the configuration paret, then I tried to use the Send Test Email, I saw it got quequed and then I clicked view database mail log, the error is Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 4 (2011-01-10T09:26:05). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it 10.5.210.160:25).
)
What does this mean, and how can I fix it?
Thanks
--------------------------------------------------------------------------------
January 10, 2011 at 9:09 am
I think it means your SMTP server has refused to accept the message request. Check you have setup database mail and smtp in particular with the correct authentication
Gethyn Elliswww.gethynellis.com
January 10, 2011 at 9:46 am
I went through the steps to setup the database mail.
On the account managing existing account screen, I setup like below:
Accountname: databasemail
Outgoing mailserver:
Emailaddress: myntemailaddress@mydomain.com
Display name: SQL Alert
Reply Email: myntemailaddress@mydomain.com
Servername: ourExchangeServername.domain.org
SMTP authentication:
use basic authentication:
then I enter my username, password.
My username is a login in sql server as a systemadmin
Any advice?
Thanks
January 10, 2011 at 10:38 am
Try to use anonymous authentication for your SMTP Server.
Thank You,
Best Regards,
SQLBuddy
January 10, 2011 at 10:49 am
I got the same error after using anonymous authentication
I just nwo went to our exchange admin guy, he said he needs to add the computer that I send the email from to allow relay. He asked me to send him the IP address of my computer.
I will do another try after he adds it.
thanks
January 10, 2011 at 4:36 pm
Did you get it sorted?
Gethyn Elliswww.gethynellis.com
January 10, 2011 at 6:11 pm
No, he added my pc's IP to the relay list, still I had the same error message, also I tried using anonymous authentication, I got the same error.
I'm testing this on my PC which has sql server 2005 developer version installed.
Any more suggestions or ideas?
Thanks
January 11, 2011 at 5:32 am
Are you sending the DB Mail from a job by any chance, I remember that the account that is used for the SQL Server Agent Service needs to be added to the databasemailuser role in the msdb database??
Just a thought??
'Only he who wanders finds new paths'
January 11, 2011 at 7:10 am
Thanks. Currently I have not sent any jobs from sql agent yet.
Just set it up and test it by using sending test email by right click on database mail
January 11, 2011 at 8:39 am
It isnt something I know too much to be honest.
I did find this link for testing a relay if that is of any use to you?
http://support.microsoft.com/kb/304897
Regards
D
'Only he who wanders finds new paths'
January 11, 2011 at 8:58 am
Thank you. I give it a try.
And I will also see what our network engineer can do.
January 11, 2011 at 1:07 pm
I would like to update this. Our network guy said he created something called Connector. Then Let me give it a try. First it didn't work, then Later he asked me to try to put another Exchange server name, (we are migration the old server to new, not all mailboxes are moved to the new one yet. ) then it works. I don't know much about exchange setup.
So I don't know which step makes it work, for I tried to change it to the old server name earlier, it didn't work either. SO I think all together make it work.
Also now I use anonymous authentication.
Thanks everyone for the help.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply