Forum Discussion
Issues with Power BI Report Server
If you go into the folder "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer"
and open the rsreportserver.config file you will find a setting called <SMTPUseSSL> I think this defaults to true.
If you are sending email via an internal smtp server then either it's SSL certificate is not valid or maybe it's not setup to use SSL. If it's not setup to use SSL, but it's not accessible via the internet then maybe it's OK to change this setting to <SMTPUseSSL>False</SMTPUseSSL>. If should be able to find out from you IT department if the smtp server is configured for SSL connections or not.
ps. I think you will have to stop and re-start PBIRS using the configuration tool for this setting to take effect.
You'll need to check the log files on your server. If you have installed to the default location you will find these in the following folder
C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles
Hopefully you will find a more detailed error in the most recent log file starting with "ReportingServicesService" (this is the service that processes subscriptions)
I'm getting this error in the log file.
Can someone please help on this error for the email subscription in report server ?
emailextension!WindowsService_0!3980!09/05/2019-00:12:09:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: Failure sending mail. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.
at System.Net.Mail.SmtpConnection.ConnectAndHandshakeAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpTransport.EndGetConnection(IAsyncResult result)
at System.Net.Mail.SmtpClient.ConnectCallback(IAsyncResult result)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(TimeSpan timeout)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
---> (Inner Exception #0) System.Net.Mail.SmtpException: Failure sending mail. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.
at System.Net.Mail.SmtpConnection.ConnectAndHandshakeAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpTransport.EndGetConnection(IAsyncResult result)
at System.Net.Mail.SmtpClient.ConnectCallback(IAsyncResult result)
--- End of inner exception stack trace ---<---If you go into the folder "C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer"
and open the rsreportserver.config file you will find a setting called <SMTPUseSSL> I think this defaults to true.
If you are sending email via an internal smtp server then either it's SSL certificate is not valid or maybe it's not setup to use SSL. If it's not setup to use SSL, but it's not accessible via the internet then maybe it's OK to change this setting to <SMTPUseSSL>False</SMTPUseSSL>. If should be able to find out from you IT department if the smtp server is configured for SSL connections or not.
ps. I think you will have to stop and re-start PBIRS using the configuration tool for this setting to take effect.