Impact Disabling “Update Root Certificates” Has On SQL Server – Managing your servers can streamline the performance of your team by allowing them to complete complex tasks faster. Plus, it can enable them to detect problems early on before they get out of hand and compromise your business. As a result, the risk of experiencing operational setbacks is drastically lower.
But the only way to make the most of your server management is to perform it correctly. And to help you do so, this article will share nine tips on improving your server management and fix some problem about windows, sql-server-2005, sql-server-2008, certificate, .
I was told that Disabling the
Update Root Certificates option from the
Windows Components section of
Add/Remove Programs will cause SQL Server to stop working properly.
It this correct, or is my friend simply misinformed?
I could see how this would prevent the checking of the list of trusted certificate authorities in the Windows update website. If your application was requiring SQL Server to use certificates (Service broker certificate authentication?) I could see this being an issue. Perhaps something like this is your friend’s point of reference.
As it turns out, my friend was referring to this Microsoft KB article. Luckily for us, this is only an issue if you are running Windows Server 2003 SP1. Since we’ve installed SP2, we are not affected by this problem.