kbennett13
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 .lockwoodi nt.com</SM TPServer>
<SMTPServerPort></SMTPServ erPort>
<SMTPAccountName></SMTPAcc ountName>
<SMTPConnectionTimeout></S MTPConnect ionTimeout >
<SMTPServerPickupDirectory >2</SMTPSe rverPickup Directory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAu thenticate >
<From>automated@lockwoodin t.com</Fro m>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML< /Rendering Extension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma ts></Privi legedUserR enderForma ts>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True </SendEmai lToUserAli as>
<DefaultHostName></Default HostName>
<PermittedHosts></Permitte dHosts>
</RSEmailDPConfiguration>
(After Change)
<RSEmailDPConfiguration>
<SMTPServer>hou-w2k8-cas01 .lockwoodi nt.com</SM TPServer>
<SMTPServerPort></SMTPServ erPort>
<SMTPAccountName></SMTPAcc ountName>
<SMTPConnectionTimeout></S MTPConnect ionTimeout >
<SMTPServerPickupDirectory >2</SMTPSe rverPickup Directory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>2</SMTPA uthenticat e>
<From>automated@lockwoodin t.com</Fro m>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML< /Rendering Extension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma ts></Privi legedUserR enderForma ts>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>Fals e</SendEma ilToUserAl ias>
<DefaultHostName></Default HostName>
<PermittedHosts></Permitte dHosts>
</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 .lockwoodi nt.com</SM TPServer>
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory >
</SMTPServerPickupDirector y>
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>2
</SMTPAuthenticate>
<From>automated@lockwoodin t.com</Fro m>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML< /Rendering Extension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma ts>
</PrivilegedUserRenderForm ats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>Fals e</SendEma ilToUserAl ias>
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
(Before changes)
<RSEmailDPConfiguration>
<SMTPServer>hou-w2k8-cas01
<SMTPServerPort></SMTPServ
<SMTPAccountName></SMTPAcc
<SMTPConnectionTimeout></S
<SMTPServerPickupDirectory
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAu
<From>automated@lockwoodin
<EmbeddedRenderFormats>
<RenderingExtension>MHTML<
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
<SendEmailToUserAlias>True
<DefaultHostName></Default
<PermittedHosts></Permitte
</RSEmailDPConfiguration>
(After Change)
<RSEmailDPConfiguration>
<SMTPServer>hou-w2k8-cas01
<SMTPServerPort></SMTPServ
<SMTPAccountName></SMTPAcc
<SMTPConnectionTimeout></S
<SMTPServerPickupDirectory
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>2</SMTPA
<From>automated@lockwoodin
<EmbeddedRenderFormats>
<RenderingExtension>MHTML<
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
<SendEmailToUserAlias>Fals
<DefaultHostName></Default
<PermittedHosts></Permitte
</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
<SMTPServerPort>
</SMTPServerPort>
<SMTPAccountName>
</SMTPAccountName>
<SMTPConnectionTimeout>
</SMTPConnectionTimeout>
<SMTPServerPickupDirectory
</SMTPServerPickupDirector
<SMTPUseSSL>
</SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate>2
</SMTPAuthenticate>
<From>automated@lockwoodin
<EmbeddedRenderFormats>
<RenderingExtension>MHTML<
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma
</PrivilegedUserRenderForm
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
<SendEmailToUserAlias>Fals
<DefaultHostName>
</DefaultHostName>
<PermittedHosts>
</PermittedHosts>
</RSEmailDPConfiguration>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The account that we were using was not able to send emails for anonymous users.
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.