March 31, 2016 at 12:21 pm
As part of the PCI initiative to disable weak ciphers, we began that process at my company. After following all the recommendation mentioned in KB3135244 and this MSDN blog post, we rolled out few development servers running with TLS 1.0 disabled.
Server A: Running SQL Server & SSRS running SQL Server 2012 SP1 (11.0.5058). Installed .NET Framework 4.6.1, SNAC 11.0.6518 (TLS 1.2 Capable)
Server B: Running SQL Server 2014 SP1 CU5 (12.00.4439). TLS 1.0 is disabled.
We are able to connect to Server B locally, and remotely from Server A using SSMS, SQL Data Tools, and even SQL Server Report Builder. The data source can be tested in any SSRS design tools without any issues. However, once deployed and ran through the SSRS webpage or through a subscription, we receive the following error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Creating a data source via the web page result in the same error. Windows Authentication or SQL Server Authentication makes no difference. Any one has any similar issues?
Has anyone been able to run reports against SQL Servers that has TLS 1.0 disabled?
April 5, 2016 at 5:18 am
Anyone got any idea?
March 14, 2019 at 4:57 am
I am facing same issue and have installed SQL Server 2012 SP4, both the report server A and database Server B have same installation and SP versions, but reports do not run giving same error mentioned earlier in this question.
Please guide.
October 28, 2019 at 10:52 am
Wasn't sure if I saw where TLS1.2 was enabled in registry on the server. Additional I think this has been mentioned, we also had to upgrade to SQL Server 2012 SP3 which has TLS 1.2 support. I'm not sure any connections are going to be allowed with TLS 1.0 disabled if TLS1.2 is also disabled
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply