Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Issues with Database miling Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 11:45 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:14 AM
Points: 280, Visits: 1,207
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
Posted Thursday, November 15, 2012 2:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 5,218, Visits: 5,072
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
Posted Thursday, November 15, 2012 2:05 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:14 AM
Points: 280, Visits: 1,207
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
Posted Thursday, November 15, 2012 2:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 5,218, Visits: 5,072
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.




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 #1385011
Posted Thursday, November 15, 2012 2:09 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:14 AM
Points: 280, Visits: 1,207
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 »

Add to briefcase

Permissions Expand / Collapse