Solved

SQL Error

Posted on 2011-09-16
10
747 Views
Last Modified: 2012-05-12
We are trying to change the Reporting server settings so that it no longer use's our exchange relay list / Server.  Just use google SMTP and have it hit a gmail account.

Here is the error I am getting:

Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.0 Must issue a STARTTLS command first. 11sm2223890ybl.27


Here is our config File for the Site we are working at.... advice would be greatly appreciated.

<Configuration>
	<RSEmailDPConfiguration>
	    <SMTPServer>smtp.gmail.com</SMTPServer>
	    <SMTPServerPort>587</SMTPServerPort>
	    <SMTPAccountName>suttonentertainment.inc@gmail.com</SMTPAccountName>
	    <SMTPConnectionTimeout></SMTPConnectionTimeout>
	    <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
	    <SMTPUseSSL>2</SMTPUseSSL>
	    <SendUsing>2</SendUsing>
	    <SMTPAuthenticate>2</SMTPAuthenticate>
	    <From>emailaddress1@gmail.com</From>
	    <EmbeddedRenderFormats>
		  <RenderingExtension>MHTML</RenderingExtension>
	    </EmbeddedRenderFormats>
	    <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
	    <ExcludedRenderFormats>
		  <RenderingExtension>HTMLOWC</RenderingExtension>
		  <RenderingExtension>NULL</RenderingExtension>
		  <RenderingExtension>RGDI</RenderingExtension>
	    </ExcludedRenderFormats>
	    <SendEmailToUserAlias>True</SendEmailToUserAlias>
	    <DefaultHostName></DefaultHostName>
	    <PermittedHosts></PermittedHosts>
	</RSEmailDPConfiguration>
</Configuration>

Open in new window

0
Comment
Question by:DG_Dan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36553032
Have you tried this with port 465, i.e., SSL versus TLS:
https://mail.google.com/support/bin/answer.py?answer=13287
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36553045
Additionally, <SMTPuseSSL /> is a boolean setting; therefore: 0 = false, 1 = true. I do not believe 2 is a valid value, but might work as true since it is not 0; however, to be safe, I would change that. Here is confirmation on what the other values mean: http://msdn.microsoft.com/en-us/library/ms157273.aspx

I have not tried to do this myself, so I can't confirm that it is possible; therefore, I checked and found at least this post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/49fd92b9-810d-4a2c-af18-a63fbf6e1a46/ that suggests you may have to setup smart host (local SMTP server) and have it relay to the gmail server. The referenced other thread shows a configuration with TLS port as you were trying and confirms my point on SMTPuseSSL as it shows with a value of TRUE and not 2.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36553060
You are trying to send mail from non secure port. and gmail only working with secure port. so please update port appropriate.
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36553084
@PatelAlpesh, thanks for repeating my suggestion. It is always good to get a second opinion. Do you see any other changes that are needed that might help the Asker?
0
 

Author Comment

by:DG_Dan
ID: 36555227
Guys,  I am going to test and try it out Monday Morning, I will keep you all posted with results / recourse.  Thank you for the Suggestions.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36944774
The issue is probably resolved in the correction of settings or use of smart host - i.e., accept http:#36553045 - but it would be nice to get confirmation from Asker. So may be worth accepting for future readers to know what to try; however, a delete is fine by me also.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 36998444
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question