Red Gate forums :: View topic - problem setting up Mail Server Settings
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

problem setting up Mail Server Settings

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Proto



Joined: 24 Nov 2009
Posts: 7

PostPosted: Tue Nov 24, 2009 7:23 pm    Post subject: problem setting up Mail Server Settings Reply with quote

I'm having an issue setting up my Mail Server Settings in SQL Response. I have used the exact same settings in SQL Backup (running on the same server) and they work just fine, emails are sent with no problems. In SQL Response, the test email fails and no alert emails are ever sent.

Very weird to say the least.

Is there a difference on how the two products handle the email server settings? Or something else that could be causing this?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Nov 25, 2009 3:49 pm    Post subject: Reply with quote

Hi Proto,

Apologies for the problems you are having.

Is the machine hosting Alert Repository able to see SMTP Server? Please try pinging the SMTP server from the Alert Repository machine and see if that works.

Also, do you see any error on the UI when the test email fails?

If the problem is still not resolved then please email us the screen shot of the "Mail Server Settings" dialog box with the error message and also the Alert Repository log file. You can obtain the log file by clicking on the SQL Response icon on the top left corner and then selecting 'Copy Alert Repository log file' in the menu.

Please email this to support@red-gate.com. Also, please put a reference to this forum post. This will help us to diagnose the issue.

Thanks a lot.

Regards,
Priya
Back to top
View user's profile Send private message
Proto



Joined: 24 Nov 2009
Posts: 7

PostPosted: Wed Nov 25, 2009 5:41 pm    Post subject: Reply with quote

yes, the machine hosting the alert repository is able to see the SMTP server. pinging it works fine. it's the same machine that is running sql backup and emails work just fine from that software.

the UI shows the basic "Failure sending email" message below the Send Test Email button.

from the log file (removed my email address):

Code:
11:25:19.082|Error  |AlertRepository     |6  |Error sending test email|System.Net.Mail.SmtpException: Transaction failed. The server response was: 5.7.1 <my_email_was_here>: Recipient address rejected: Access denied
   at System.Net.Mail.RecipientCommand.CheckResponse(SmtpStatusCode statusCode, String response)
   at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)
   at System.Net.Mail.SmtpClient.Send(MailMessage message)
   at e.a(a , RepositoryConfiguration , Boolean )
   at e.a(String , RepositoryConfiguration , String& )
11:25:39.174|Error  |AlertRepository     |37 |Error sending test email|System.Net.Mail.SmtpException: Transaction failed. The server response was: 5.7.1 <my_email_was_here>: Recipient address rejected: Access denied
   at System.Net.Mail.RecipientCommand.CheckResponse(SmtpStatusCode statusCode, String response)
   at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception)
   at System.Net.Mail.SmtpClient.Send(MailMessage message)
   at e.a(a , RepositoryConfiguration , Boolean )
   at e.a(String , RepositoryConfiguration , String& )


after looking at the log i tried changing the recipient address to another valid email address and the same error occurs.


will send this to support as well.
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Wed Nov 25, 2009 6:07 pm    Post subject: Reply with quote

You will need to have a friendly chat with your Sys Admin.

Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restriction to prevent Spam and Malware propagation.

I'm guessing the machine that you are using for the SQL Response Alert Repository is not a SQL Server and therefore might not be white listed to have sending privileges on the SMTP Server.

Cheers,
--
Daniel
Back to top
View user's profile Send private message
Proto



Joined: 24 Nov 2009
Posts: 7

PostPosted: Wed Nov 25, 2009 7:57 pm    Post subject: Re: Reply with quote

dlkj wrote:
You will need to have a friendly chat with your Sys Admin.

Your company SMTP server has been configured to reject certain email addresses or sending machines. This is a common restriction to prevent Spam and Malware propagation.

I'm guessing the machine that you are using for the SQL Response Alert Repository is not a SQL Server and therefore might not be white listed to have sending privileges on the SMTP Server.

Cheers,
--
Daniel


As I said, I use the exact same settings in SQL Backup (running on the exact same server (it's the SQL server)) and they work just fine, emails are sent with no problems.
Back to top
View user's profile Send private message
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Thu Nov 26, 2009 11:02 am    Post subject: Reply with quote

I'm sorry to say that the only person who can fix this is the admin of your SMTP server.

SQL Response and SQL Backup do not use the same SMTP library, so this may cause a difference which is causing the SMTP server to reject the email.

The log file shows that the only error is caused by the SMTP Server rejecting the send request.

This is a security issue rather than a bug.

Let me know if you need any further information to help you resolve this.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group