SSRS and subscriptions with office365
-
Hi.I have a detail with the subscriptions in Reporting Services (SQL Server 2014).I have configured DBmail using Office365.
When I run the report to send it by mail it sends:
Failure sending mail: Error in processing. The server response was: 5.7.3 STARTTLS is required to send mail [BN6PR03CA0006.namprd03.prod.outlook.com]Mail will not be resent.
I opened the regedit and put the TLS 2.1 manually but there was no change.
Could you help me ?
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
You using port 587 or port 25?
Also using smtp.office365.com as the smtp address?
-
I am using 587 port.
Yes, I am using smp.office365.com as smtp
-
MS does everything so that the systems will not work if they are not in AZURE!
They want you to use both AAD and Graph
-
izhar-azati, thanks for you message.
-
What is the patchversion of SQL Server 2014 ? It could be that TLS 1.2 is now required
-
Hello Jo Pattyn.
Microsoft SQL Server 2014 (SP3-GDR) (KB4532095) - 12.0.6118.4 (X64)
Dec 12 2019 21:46:15
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: ) (Hypervisor)
-
For TLS 1.2 you'll need version 11.0.6216.27 https://support.microsoft.com/en-us/help/3135244/kb3135244-tls-1-2-support-for-microsoft-sql-server
Might als wel update to SP4 + CU + security fix https://sqlserverbuilds.blogspot.com/#sql2014x.
Can't verify it because our servers are 2017+
-
Ok, I'm going to do tests
thanks Jo.
-
Hiy Mariomoyeda ,
i have same issue ,
did you solve the problem ?
thanks .
-
Helo umutalkim.
I still haven't been able to solve it. I'm setting up a server and doing what Jo Pattyn suggests.Regards
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply