Difference between revisions of "SQL Server and TLS 1.2"
(→SQL Server Versions Supporting TLS 1.2) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 31: | Line 31: | ||
==Applying Updates to SQL Server== | ==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 | + | 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== | ==SQL Server Clients Support TLS 1.2== | ||
| Line 42: | 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:Databases-MSSQL]] | ||
Latest revision as of 20:34, 16 March 2016
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
These are the SQL Server version and update levels that will function with TLS 1.0 disabled.
| Version | Update | Download Link |
|---|---|---|
| SQL 2012 SP2 | Cumulative Update 10 | https://www.microsoft.com/en-us/download/details.aspx?id=50731 |
| SQL 2012 SP3 | Cumulative Update 1 | https://www.microsoft.com/en-us/download/details.aspx?id=50733 |
| SQL 2014 RTM | Cumulative Update 12 | https://www.microsoft.com/en-us/download/details.aspx?id=51187 |
| SQL 2014 SP1 | Cumulative Update 5 | 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 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
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.