|SQL Server system RSA compatibility||Check whether SQL Server is compatible with RSA BSAFE upgrade to 6.2.1 which will allow to make connection with McAfee ePO with new RSA 2048-bit keys support. This check might take a little time.||Failed||Cipher suite order is not correct. Use Group Policy Editor to change it.See McAfee KB87731 for more information.|
The solution to this issue is reordering the cipher suites following McAfee KB87731 article which point to two Microsoft articles.
Reordering the ciphers manually was challenging, as the instruction provided on both Microsoft articles below are not very clear to me on how to reorder the ciphers using Windows group police:
- “Update to add new cipher suites to Internet Explore and Microsoft Edge in Windows”
- “Prioritizing Schannel Cipher Suites”
On my first attempt to reorder the ciphers I broke the SSL connection to my SQL server. After couple of rollbacks during the upgrade of ePO I was able to identify the issue, it was with the way I reorder the ciphers. Looking for a solution I stumble on a tool called IIS Crypto. IIS Crypto is a free tool that gives administrators the ability to enable or disable protocols, ciphers, hashes and key exchange algorithms on Windows Server 2008, 2012, 2016 and 2019.
The tool is very simple to use and I will show how to use it to reorder the ciphers with very little effort.
Note: This process requires a reboot of the SQL server, it is important to schedule a reboot.
How to reorder ciphers using IIS Crypto GUI
- Download the tool from Nartac.
- Next click on save file.
- Once the tool is downloaded, double click on the executable.
- On the next windows click “Run”.
- Accept the license agreement.
- Next on the left side, click on Cipher Suites.
- Next click on Best Practices.
- Follow by selecting “Reboot” and then click “Apply” Note: This process requires a reboot of the SQL server, it is important to schedule a reboot.
Once the SQL server is rebooted test the connectivity to the database. If you are not sure how to test connectivity to the database using .udl file, go to this article “How To Test Connectivity To The Database Using UDL file“.
This concludes the procedure on how to reorder the ciphers suites on SQL server. If you have any questions or comments please let me know.