CODEWITHSUNDEEP
reportingservices-2005exchange-server-2010
Dewasish Mitruka
Dewasish Mitruka

Reputation: 2896

SSRS email Subscription Using Exchange server 2010

Can it is possible to sent SSRS (SQL SERVER REPORTING SERVICE) 2005 email subscription using Microsoft Exchange server 2010 instead of SMTP? If possible than how?

We have tried to do it by editing the file rsreportserver.config.

We had change the below section of the code:

 <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> 
                    <MaxRetries>3</MaxRetries> 
                    <SecondsBeforeRetry>900</SecondsBeforeRetry> 
                    <Configuration> 
                         <RSEmailDPConfiguration> 
                              <SMTPServer>xxx.xx.xx.xxx</SMTPServer> //Ip Address
                              <SMTPServerPort></SMTPServerPort> 
                              <SMTPAccountName></SMTPAccountName> 
                              <SMTPConnectionTimeout></SMTPConnectionTimeout> 
                              <SMTPServerPickupDirectory></SMTPServerPickupDirectory> 
                              <SMTPUseSSL></SMTPUseSSL> 
                              <SendUsing>2</SendUsing> 
                              <SMTPAuthenticate></SMTPAuthenticate> 
                              <From>[email protected]</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> 
               </Extension>

Upvotes: 1

Views: 871

Answers (1)

Dave Markle
Dave Markle

Reputation: 97711

Unfortunately, looking through the documentation, it looks as though SSRS can't be configured to use Exchange Web Services, even in SQL Server 2012.

Pretty weak. It's as though they pretty much stopped any significant development of SSRS the day it went live.

Upvotes: 1

Related Questions