Post reply

How to configure SSRS 2008 R2 Subscription to send external mails.

  • December 15, 2011 at 7:33 am

    #264868

    Hi All,

    Right now I am able to send mails through SSRS 2008 R2 subscription over the intranet, But i am unable to do so for external mails.

    I changed the

    SMTPServer to mail.mystifly.com

    port number to 25

    send using to 2

    SMTPAuthenticate to 2

    From to notify@mystifly.com

    I use the same email to send external mails from Database Mail.

    What more modifications should i make to the config file to do so.

    <Configuration>

    <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAK8JmANhiq0qFlBvG6l5IRAQAAAAiAAAAUgBlAHAAbwBy

    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAABBmAAAAAQAAIAAAACB01K4UGdzvVPwvm+QUW/93p1be

    kxagOv8Cyb4TUgHYAAAAAA6AAAAAAgAAIAAAAKhq2kkZxcU83nuXhXyp1ccX8W2tthhFwt8Szv2s

    WJGo4AAAACah/9ob0yu80sLePu7mg/Usm7QPJ0L/9/3UQ+dCHcmzauslj6em6cGINHhfVbAxqncq

    A07Kn5rRtx/JmzTqXYLs2A5o6d28s4FqzQ7MBotS70Dz13CwWGh9b7gFnkUUkUf3qTv+mBJQDBKZ

    HHQAzwgWYrDh/tQ7p6BiYiVbhf6lPYrdHfEounWEA4LwljdnvDp+CS0gQW+mBQwRy2ZAoyAYeT3U

    h+PLOc8ktBOTy2I7XGTGRTA5cbbs7HxsNDrtNOzsX4Cwg9U9fWZQovRXDJ7rDBxEjXWV7ICuGr9B

    MisZQAAAAG5yeUCSIJnc9KoAEPWdEZx7FlxMSQ+y2jRSDqK5T2n0KFVxwFHdcs4igA5rBWeMXBGw

    jNwv+KEeKGz3QAGnsZw=</Dsn>

    <ConnectionType>Default</ConnectionType>

    <LogonUser></LogonUser>

    <LogonDomain></LogonDomain>

    <LogonCred></LogonCred>

    <InstanceId>MSRS10_50.MSSQLSERVER</InstanceId>

    <InstallationID>{1b1d38b1-a410-436f-95af-40a4b6d7ca2e}</InstallationID>

    <Add Key="SecureConnectionLevel" Value="0"/>

    <Add Key="CleanupCycleMinutes" Value="10"/>

    <Add Key="MaxActiveReqForOneUser" Value="20"/>

    <Add Key="DatabaseQueryTimeout" Value="120"/>

    <Add Key="RunningRequestsScavengerCycle" Value="60"/>

    <Add Key="RunningRequestsDbCycle" Value="60"/>

    <Add Key="RunningRequestsAge" Value="30"/>

    <Add Key="MaxScheduleWait" Value="5"/>

    <Add Key="DisplayErrorLink" Value="true"/>

    <Add Key="WebServiceUseFileShareStorage" Value="false"/>

    <!-- <Add Key="ProcessTimeout" Value="150" /> -->

    <!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->

    <!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->

    <!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->

    <!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->

    <Add Key="WatsonFlags" Value="0x0428"/>

    <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>

    <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException"/>

    <URLReservations>

    <Application>

    <Name>ReportServerWebService</Name>

    <VirtualDirectory>ReportServer</VirtualDirectory>

    <URLs>

    <URL>

    <UrlString>http://+:8080</UrlString&gt;

    <AccountSid>S-1-5-20</AccountSid>

    <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>

    </URL>

    </URLs>

    </Application>

    <Application>

    <Name>ReportManager</Name>

    <VirtualDirectory>Reports</VirtualDirectory>

    <URLs>

    <URL>

    <UrlString>http://+:8080</UrlString&gt;

    <AccountSid>S-1-5-20</AccountSid>

    <AccountName>NT AUTHORITY\NETWORKSERVICE</AccountName>

    </URL>

    </URLs>

    </Application>

    </URLReservations>

    <Authentication>

    <AuthenticationTypes>

    <RSWindowsNegotiate/>

    <RSWindowsNTLM/>

    </AuthenticationTypes>

    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>

    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>

    <EnableAuthPersistence>true</EnableAuthPersistence>

    </Authentication>

    <Service>

    <IsSchedulingService>True</IsSchedulingService>

    <IsNotificationService>True</IsNotificationService>

    <IsEventService>True</IsEventService>

    <PollingInterval>10</PollingInterval>

    <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>

    <MemorySafetyMargin>80</MemorySafetyMargin>

    <MemoryThreshold>90</MemoryThreshold>

    <RecycleTime>720</RecycleTime>

    <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>

    <MaxQueueThreads>0</MaxQueueThreads>

    <UrlRoot>

    </UrlRoot>

    <UnattendedExecutionAccount>

    <UserName></UserName>

    <Password></Password>

    <Domain></Domain>

    </UnattendedExecutionAccount>

    <PolicyLevel>rssrvpolicy.config</PolicyLevel>

    <IsWebServiceEnabled>True</IsWebServiceEnabled>

    <IsReportManagerEnabled>True</IsReportManagerEnabled>

    <FileShareStorageLocation>

    <Path>

    </Path>

    </FileShareStorageLocation>

    </Service>

    <UI>

    <ReportServerUrl>

    </ReportServerUrl>

    <PageCountMode>Estimate</PageCountMode>

    </UI>

    <Extensions>

    <Delivery>

    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <FileShareConfiguration>

    <ExcludedRenderFormats>

    <RenderingExtension>HTMLOWC</RenderingExtension>

    <RenderingExtension>NULL</RenderingExtension>

    <RenderingExtension>RGDI</RenderingExtension>

    </ExcludedRenderFormats>

    </FileShareConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <RSEmailDPConfiguration>

    <SMTPServer>192.168.0.200</SMTPServer>

    <SMTPServerPort>250

    </SMTPServerPort>

    <SMTPAccountName>

    </SMTPAccountName>

    <SMTPConnectionTimeout>

    </SMTPConnectionTimeout>

    <SMTPServerPickupDirectory>

    </SMTPServerPickupDirectory>

    <SMTPUseSSL>

    </SMTPUseSSL>

    <SendUsing>2</SendUsing>

    <SMTPAuthenticate>

    </SMTPAuthenticate>

    <From>nithin@mystifly.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>

    </Extension>

    <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">

    <MaxRetries>3</MaxRetries>

    <SecondsBeforeRetry>900</SecondsBeforeRetry>

    <Configuration>

    <DocumentLibraryConfiguration>

    <ExcludedRenderFormats>

    <RenderingExtension>HTMLOWC</RenderingExtension>

    <RenderingExtension>NULL</RenderingExtension>

    <RenderingExtension>RGDI</RenderingExtension>

    </ExcludedRenderFormats>

    </DocumentLibraryConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>

    </Delivery>

    <DeliveryUI>

    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">

    <DefaultDeliveryExtension>True</DefaultDeliveryExtension>

    <Configuration>

    <RSEmailDPConfiguration>

    <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

    </RSEmailDPConfiguration>

    </Configuration>

    </Extension>

    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>

    </DeliveryUI>

    <Render>

    <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>

    <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>

    <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>

    <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>

    <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>

    <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

    <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

    <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>

    <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>

    <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>

    </Render>

    <Data>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/>

    <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>

    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

    </Data>

    <SemanticQuery>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>False</EnableMathOpCasting>

    </Configuration>

    </Extension>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>True</EnableMathOpCasting>

    <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>

    <EnableUnistr>False</EnableUnistr>

    <DisableTSTruncation>False</DisableTSTruncation>

    </Configuration>

    </Extension>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">

    <Configuration>

    <EnableMathOpCasting>True</EnableMathOpCasting>

    <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>

    </Configuration>

    </Extension>

    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/>

    </SemanticQuery>

    <ModelGeneration>

    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>

    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/>

    </ModelGeneration>

    <Security>

    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>

    </Security>

    <Authentication>

    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>

    </Authentication>

    <EventProcessing>

    <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

    <Event>

    <Type>ReportHistorySnapshotCreated</Type>

    </Event>

    </Extension>

    <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

    <Event>

    <Type>TimedSubscription</Type>

    </Event>

    </Extension>

    <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">

    <Event>

    <Type>RefreshCache</Type>

    </Event>

    </Extension>

    <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

    <Event>

    <Type>SnapshotUpdated</Type>

    </Event>

    </Extension>

    </EventProcessing>

    </Extensions>

    <MapTileServerConfiguration>

    <MaxConnections>2</MaxConnections>

    <Timeout>10</Timeout>

    <AppID>(Default)</AppID>

    <CacheLevel>Default</CacheLevel>

    </MapTileServerConfiguration>

    </Configuration>

  • December 15, 2011 at 7:45 am

    #1421960

    There is nothing for you to do on your SQL Server, but the mail server you are using must allow relaying to external email addresses, and be able to forward mail to external mail servers. This is typically a configruation done by your email administrator.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • December 16, 2011 at 12:09 am

    #1422322

    Let me check with the IT guys about the SMTP settings.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply