shamshad.ali - Monday, June 25, 2018 3:42 AM

Do I need to run any update on the database server running SQL Server 2008 R2?

You will need to apply the necessary client component fixes on the server that hosts the SQL Server instance (eg. MS ODBC Driver, SQL Server Native Client) to ensure that the client components installed on the server also support TLS 1.2.

Installing any update is not allowed on db server running 2008 R2 because it is 3rd party configured and we only want to setup connecting this server for reporting (service using 2016 version) purpose. Is there any workaround for this? 
I also see following link 

https://support.microsoft.com/en-us/help/3099845/hotfix-rollup-3099845-for-the-net-framework-4-5-2-4-5-1-and-4-5

This hotfix enables Transport Layer Security (TLS) 1.1/1.2 for SQL Server connectivity in System.Data.dll.

This is risky and can't do becase several third party applications are using database running on this DB servrer. 
Please help.