SQL profile not sending mail outside the domain

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL profile not sending mail outside the domain

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2009-02-02 : 09:29:18

I have created a database mail profile
This profile is able to send mail to our company emailids but not to outside emailids

it gives following error in mail log

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-02-02T19:22:55). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: <abcd@yahoo.com>: Relay access denied).

when i try to change smtp authentication account it gives following error

Update account 'dbmailacc' for SMTP server 'mailserver.com' (Error)
Unable to update account dbmailacc for SMTP server Microsoft.SqlServer.Management.SqlManagerUI.SQLiMailServer.
Set mail server login password failed for MailServer 'mailserver.com'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
An error occurred during decryption. (Microsoft SQL Server, Error: 15466)

any help would be greatly appreciated

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-02 : 09:32:54

Are you sure you used correct password?

quote:
Set mail server login password failed

E 12°55'05.63"
N 56°04'39.26"

heavymind
Posting Yak Master

115 Posts

Posted - 2009-02-02 : 09:33:07

Are you able to send outside mails using for instance outlook express with this account? check the mail server settings...

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-02-02 : 15:55:49

When this error message appears, outside of sql, you need to enable outgoing server authentication.

It appears to me your sql server may be attempting to deliver mail for yahoo via a server w/o relay permission.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources