SSRS configuration to email subscriptions using Office365

Question

How do I configure SSRS to email subscriptions using Office365?

Answer 1

Hi @Dick Schroth

I found this thread: https://stackoverflow.com/questions/74720730/sql-server-reporting-services-mail-settings-for-office365.

You can make the following settings in the E-mail Settings of the Report Server Configuration Manager:

smtp server: smtp.office365.com,

authentication: Username and Password (Basic),

and enter the user credentials of the user who has his own Maibox.

Also, the SMTP library used by SSRS is old and hasn't been updated and can be buggy, so TLS 1.2 also needs to be enforced and .NET enforced.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Answer 2

Thanks for your answer, but I am still unable to get it working.

When I try to configure Email Settings using the Reporting Services Configuration Manager, it only asks me 2 things: Sender Address and SMTP Server. It never even asks for the password or anything about security. So I have no idea how to specify the authentication type or how to enforce TLS 1.2 or .NET. Here is the section from the rsreportserver.config file about the email settings:

<RSEmailDPConfiguration>
				<SMTPServer>smtp.office365.com</SMTPServer>
						<SMTPServerPort>
						</SMTPServerPort>
						<SMTPAccountName>
						</SMTPAccountName>
						<SMTPConnectionTimeout>
						</SMTPConnectionTimeout>
						<SMTPServerPickupDirectory>
						</SMTPServerPickupDirectory>
						<SMTPUseSSL>
						</SMTPUseSSL>
						<SendUsing>2</SendUsing>
						<SMTPAuthenticate>
						</SMTPAuthenticate>
						<From>******@domainname.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>

So I'm trying to figure out how I can change this so it will work? It seems like at a minimum I need to store the password somehow, and I might like to specify the port, authentication method, etc as well.

Answer 3

Hi @Dick Schroth

Can you open the Report Server Configuration Manager? In the E-mail Settings tab, you can also configure it. Select Username and Password (Basic) to set the username and password.

You can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/e-mail-settings-reporting-services-native-mode-configuration-manager?view=sql-server-ver16#configure-report-server-e-mail-using-the-report-server-configuration-manager.

Best regards,

Aniya