SQL Server and TLS 1.2 - Revision history

Davidd at 20:34, 16 March 2016

2016-03-16T20:34:05Z

Davidd at 20:33, 16 March 2016

2016-03-16T20:33:22Z

Davidd: /* Applying Updates to SQL Server */

2016-03-14T19:16:02Z

‎Applying Updates to SQL Server

Davidd: /* SQL Server Versions Supporting TLS 1.2 */

2016-03-14T19:15:15Z

‎SQL Server Versions Supporting TLS 1.2

Davidd: /* SQL Server Versions Supporting TLS 1.2 */

2016-03-14T19:15:04Z

‎SQL Server Versions Supporting TLS 1.2

Davidd: Created page with "Due to PCI DSS requirements, many sites and servers have disabled support for TLS versions older than 1.2. For servers that have MS SQL Server installed, this can cause failu..."

2016-03-14T19:12:16Z

Created page with "Due to PCI DSS requirements, many sites and servers have disabled support for TLS versions older than 1.2. For servers that have MS SQL Server installed, this can cause failu..."

New page

Due to PCI DSS requirements, many sites and servers have disabled support for TLS versions older than 1.2. For servers that have MS SQL Server installed, this can cause failure for the SQL Server to start if the appropriate version and update are not installed.

==SQL Server Versions Supporting TLS 1.2==

{| class="wikitable"
|-
! Version
! Update
! Download Link
|-
| style="padding: 5px;" |SQL 2012 SP2
| style="padding: 5px;" |Cumulative Update 10
| style="padding: 5px;" |https://www.microsoft.com/en-us/download/details.aspx?id=50731
|-
| style="padding: 5px;" |SQL 2012 SP3
| style="padding: 5px;" |Cumulative Update 1
| style="padding: 5px;" |https://www.microsoft.com/en-us/download/details.aspx?id=50733
|-
| style="padding: 5px;" |SQL 2014 RTM
| style="padding: 5px;" |Cumulative Update 12
| style="padding: 5px;" |https://www.microsoft.com/en-us/download/details.aspx?id=51187
|-
| style="padding: 5px;" |SQL 2014 SP1
| style="padding: 5px;" |Cumulative Update 5
| style="padding: 5px;" |https://www.microsoft.com/en-us/download/details.aspx?id=51186
|}
Source: https://support.microsoft.com/en-us/kb/3052404

==Applying Updates to SQL Server==

You can apply the update to your SQL Server instance by downloading the installer and running it on the server with the SQL instance. The SQL Service will need to be stopped during update, and the update may require a reboot. Therefore, an update should only be applied during off-peak/maintenance hours for production environments.

==SQL Server Clients Support TLS 1.2==

After applying the update and removing support for TLS 1.0, all clients connecting to SQL Server remotely will need to support TLS 1.2. If you encounter any issues connecting remotely with SQL Management Studio, we recommend that on the remote PC that is having issues connecting, you update SQL Server Management Studio to match the version of SQL Server that was installed on the server and also install the latest .Net version (download link: https://www.microsoft.com/en-us/download/details.aspx?id=49981).

NOTE: The same installer that was used to update the server can be used to update SQL Management Studio.

[[User:Davidd|Davidd]] ([[User talk:Davidd|talk]]) 14:12, 14 March 2016 (CDT)

← Older revision		Revision as of 20:34, 16 March 2016
Line 44:		Line 44:


−	[[Category:MSSQL]]	+	[[Category:Databases-MSSQL]]

← Older revision		Revision as of 20:33, 16 March 2016
Line 41:		Line 41:

	[[User:Davidd\|Davidd]] ([[User talk:Davidd\|talk]]) 14:12, 14 March 2016 (CDT)		[[User:Davidd\|Davidd]] ([[User talk:Davidd\|talk]]) 14:12, 14 March 2016 (CDT)
		+
		+
		+
		+	[[Category:MSSQL]]

@@ Line 3: / Line 3: @@
 ==SQL Server Versions Supporting TLS 1.2==
-This are the SQL Server version and update levels that will function with TLS 1.0 disabled.
+These are the SQL Server version and update levels that will function with TLS 1.0 disabled.
 {| class="wikitable"

@@ Line 31: / Line 31: @@
 ==Applying Updates to SQL Server==
-You can apply the update to your SQL Server instance by downloading the installer and running it on the server with the SQL instance.  The SQL Service will need to be stopped during update, and the update may require a reboot.  Therefore, an update should only be applied during off-peak/maintenance hours for production environments.
+You can apply the update to your SQL Server instance by downloading the installer from the appropriate link above and running it on the server with the SQL instance.  The SQL Service will be stopped during update, and the update may require a reboot.  Therefore, an update should only be applied during off-peak/maintenance hours for production environments.
-−
 ==SQL Server Clients Support TLS 1.2==