October 29, 2007 at 9:41 am
SQL2005 Ent. Edition on a w2k3 cluster . Same issue on 2 instances 1 running sp1 and the other sp2.
My problem is I setup Database mail and it tests fine via the GUI and it works via sp_send_dbmail.
However when I try to setup email notification in sql agent job failures
it will not work. My work around for now is I added a step and run sp_send_dbmail if the prior step fails and it works fine.
I see many people are having these issues but I cannot get mine to work.
Steps I have tried and it still will not work.
1: Setup dbmail and profile
2: added operator ?? Did that last
3: enabled mail profile via alert system in sql agent
4: stopped and started sql server and sql agent.
Please help. I know I am not alone but I still cannot get this to work on 2 instances.
Here is the error
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2007-10-29T10:40:37). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.).
)
October 30, 2007 at 9:03 am
This message indicates the operator has an invalid e-mail address, this is appears to be a response from your SMTP relay. Check the database mail logs. Try to reproduce with a new operator - i.e.
EXEC msdb.dbo.sp_add_operator @name=N'TEST',
@enabled=1,
@pager_days=0,
@email_address=N'someemailaddress@yourcompany.com'
Confirm you can access the SMTP relay from both nodes on the cluster -
http://support.microsoft.com/kb/153119
Good luck 🙂
Tommy
Follow @sqlscribeOctober 30, 2007 at 2:04 pm
Looks like you used an invalid email address, maybe an Active Directory user name? Ensure that you are providing the profile a valid email address. ie. bobjones@mydomain.com
Check out this profile Account 2
Good Luck!
jim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply