Issues with Database miling

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Issues with Database miling

Issues with Database miling

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanan_tvr

Posted Wednesday, November 14, 2012 11:45 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Hi all,

Am getting the error frequently when i attempting to send a mail from SQL: Please let me know to overcome this issues..

I 'm able to ping the same SMTP server from my SQl server then its says the below error:

Note: I dont have IIS server in SQl server hosted server

Date 11/15/2012 7:42:18 AM
Log Database Mail (Database Mail Log)

Log ID 39
Process ID 3228
Mail Item ID 12
Last Modified 11/15/2012 7:42:18 AM
Last Modified By sa

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2012-11-15T07:42:18). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay).
)

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1384984

anthony.green

Posted Thursday, November 15, 2012 2:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Speak to your mail admin person, they should be able to help.

But it looks like your trying to send a mail to an address which doesnt exist.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1385009

Saravanan_tvr

Posted Thursday, November 15, 2012 2:05 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Thanks, But we need to have the IIS server on SQl server server machine? or else What are the prerequisites for DB mail profiling...

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1385010

anthony.green

Posted Thursday, November 15, 2012 2:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

No you dont need IIS.

You need to ensure that the server can connect to the relay machine, you send to a valid email address and that mass mail worms are unblocked from any antivirus that blocks them.

Post #1385011

Saravanan_tvr

Posted Thursday, November 15, 2012 2:09 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Thanks for the swift response ..... I will ping with Sysadmin..

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1385012

« Prev Topic | Next Topic »

Permissions