Link to home
Start Free TrialLog in
Avatar of kbennett13
kbennett13Flag for United States of America

asked on

SSRS Problems sending to email OutSide network SQL Server 2008

We recently migrated from SQL Server 2005 to SQL Server 2008. While running SQL Server 2005 I made the following changes to rsreportserver.config file so we can begin sending reports to emails outside our network
(Before changes)
<RSEmailDPConfiguration>
                                    <SMTPServer>hou-w2k8-cas01.lockwoodint.com</SMTPServer>
                                    <SMTPServerPort></SMTPServerPort>
                                    <SMTPAccountName></SMTPAccountName>
                                    <SMTPConnectionTimeout></SMTPConnectionTimeout>
                                    <SMTPServerPickupDirectory>2</SMTPServerPickupDirectory>
                                    <SMTPUseSSL></SMTPUseSSL>
                                    <SendUsing>2</SendUsing>
                                    <SMTPAuthenticate></SMTPAuthenticate>
                                    <From>automated@lockwoodint.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>

(After Change)
<RSEmailDPConfiguration>
                                    <SMTPServer>hou-w2k8-cas01.lockwoodint.com</SMTPServer>
                                    <SMTPServerPort></SMTPServerPort>
                                    <SMTPAccountName></SMTPAccountName>
                                    <SMTPConnectionTimeout></SMTPConnectionTimeout>
                                    <SMTPServerPickupDirectory>2</SMTPServerPickupDirectory>
                                    <SMTPUseSSL></SMTPUseSSL>
                                    <SendUsing>2</SendUsing>
                                    <SMTPAuthenticate>2</SMTPAuthenticate>
                                    <From>automated@lockwoodint.com</From>
                                    <EmbeddedRenderFormats>
                                          <RenderingExtension>MHTML</RenderingExtension>
                                    </EmbeddedRenderFormats>
                                    <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
                                    <ExcludedRenderFormats>
                                          <RenderingExtension>HTMLOWC</RenderingExtension>
                                          <RenderingExtension>NULL</RenderingExtension>
                                          <RenderingExtension>RGDI</RenderingExtension>
                                    </ExcludedRenderFormats>
                                    <SendEmailToUserAlias>False</SendEmailToUserAlias>
                                    <DefaultHostName></DefaultHostName>
                                    <PermittedHosts></PermittedHosts>
                              </RSEmailDPConfiguration>


However when I made the same changes to  <SMTPAuthenticate> to 2 and <SendEmailToUserAlias> to False rsreportserver.config file for SQL Server 2008 I get this error
“Failure sending mail: The message could not be sent to the SMTP server.
The transport error code was 0x800ccc69. The server response
was 550 5.7.1 Client does not have permissions to send as this sender.”

Can’t imagine what is going wrong.

<RSEmailDPConfiguration>
                                    <SMTPServer>hou-w2k8-cas01.lockwoodint.com</SMTPServer>
                                    <SMTPServerPort>
                                    </SMTPServerPort>
                                    <SMTPAccountName>
                                    </SMTPAccountName>
                                    <SMTPConnectionTimeout>
                                    </SMTPConnectionTimeout>
                                    <SMTPServerPickupDirectory>
                                    </SMTPServerPickupDirectory>
                                    <SMTPUseSSL>
                                    </SMTPUseSSL>
                                    <SendUsing>2</SendUsing>
                                    <SMTPAuthenticate>2
                                    </SMTPAuthenticate>
                                    <From>automated@lockwoodint.com</From>
                                    <EmbeddedRenderFormats>
                                          <RenderingExtension>MHTML</RenderingExtension>
                                    </EmbeddedRenderFormats>
                                    <PrivilegedUserRenderFormats>
                                    </PrivilegedUserRenderFormats>
                                    <ExcludedRenderFormats>
                                          <RenderingExtension>HTMLOWC</RenderingExtension>
                                          <RenderingExtension>NULL</RenderingExtension>
                                          <RenderingExtension>RGDI</RenderingExtension>
                                    </ExcludedRenderFormats>
                                    <SendEmailToUserAlias>False</SendEmailToUserAlias>
                                    <DefaultHostName>
                                    </DefaultHostName>
                                    <PermittedHosts>
                                    </PermittedHosts>
                              </RSEmailDPConfiguration>
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

this is a issue with your config in SMTP, and not sql.

for email going external, there is a relay happening, and so you need to authorize the relay in SMTP.  in the case of SQL email, make sure the IP address of your SQL server is allowed to relay in SMTP (this is configured in SMTP)

you can confirm if this is your issue by checking SMTP logs.
ASKER CERTIFIED SOLUTION
Avatar of Andrei Fomitchev
Andrei Fomitchev
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kbennett13

ASKER

The account that we were using was not able to send emails for anonymous users.