Unable to send email alerts in SQL server 2005
-
I am using SQL Server 2005. I have set database mail on other server and works well and i do know all the steps involved it it. But on this servers i did all the steps to setup the mail profile for a user. but when i send a test email by right clicking on the database mail it doesn't send an email and fails. thougth there are other profiles on the server and they all works great and receives email alerts at all times.
Now for troubleshooting i used googled and found two great articles and also followed them but nothing happened. Please take a look at the articles.
--- http://www.sqlhacks.com/pmwiki.php/Administration/Database-Mail-Troubleshooting
and to check the status of the emails sent successfully or failed i use the below script--
SELECT TOP 100 *
FROM sysmail_sentitems
ORDER BY mailitem_id DESC
-----TO CHECK THE STATUS OF THE MAILS THAT ARE NOT SENT
SELECT TOP 100 *
FROM sysmail_FailedItems f
INNER JOIN dbo.sysmail_log l ON f.mailitem_id = l.mailitem_id
ORDER BY f.sent_Date DESC
now the failed part-------
shows me the error as
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2010-06-21T11:12:41). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for aangie@ibmcore.org). )
need some solution soon since its very urgent. any help or ideas is appreciated.
-
Can someone help me out please??
-
First, we are volunteers on this site. We answer questions when we can and if we are able to assist.
Second, have you checked with the administrator of your mail server to see what is occuring on that end? As a DBA/Developer, the error message you provided looks like the problem may be on the mail server side.
-
Unable to relay for aaaaaa@bbbbbb.org
Relaying is a priviledged operation on a mail server. You have to make sure the IP address of the sql server is listed in the addresses allowed for relaying.
You'd better strip off those (real) e-mail addresses from your previous post.
-- Gianluca Sartori
-
i checked and the mail server is ok. Any other area where to look into.
-
Are you able to send to any other recipient from the server? Try sending yourself an email from the sql server and see if that works.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
This might be a stupid suggestion but is it the default profile? The other day i had a issue where the mail wouldnt send and it was because i had linked the account to a public profile and had it muffled. I reversed the setting and it worked (but typing this i feel muddles again :ermm:) EIther way check that the setup of account to profile is the same as one that works.
Adam Zacks-------------------------------------------Be Nice, Or Leave
-
all the profiles are public and the one i am trying to send emails is set to default profile.
-
this clearly identifies the issue, and it's outside of SQL server:
The server response was: 5.7.1 Unable to relay for aangie@ibmcore.org). )
that is one of the standard SMTP error messages.
that means the procedure from SQL succcessfully sent the email, but the server decided that you must be a spammer, and does not permit relaying.
usually, you'd need to do one of two things: most servers allow relaying IF you used AUTH to send the username and password for the account (in this case aangie@ibmcore.org) that's just going to require editing the profile, asnd making sure you put in the username and password:
you can also set up an exception on the SMTP server to allow relaying from the IP address of the SQL server.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply