There may be a time where you install security patch MS15-058, and it shows that it was successfully installed, but the version does not change in SQL. The patch actually failed to install. Follow these instructions get to MS15-058 installed successfully and have the version change within SQL.
No need to install MS15-058 if you see this version (GDR) on your system. Some versions of SQL does not need to have the security patch installed those version are as follows:
SQL 2008 SP4 – 10.0.6241.0
SQL 2008 R2 SP2 – 10.50.4042.0
SQL 2008 R2 SP3 – 10.50.6220.0
SQL 2012 SP1 – 11.0.5313.0
SQL 2012 SP2 – 11.0.5343.0
No need if running SQL 2012 SP3
SQL 2014 SP1 – 12.0.4213.0
This Fix requires a reboot so this needs to be done during a maintenance window.
If you want to look to see if the security patch was installed but failing, you should look at the logs directory. The folders under Logs will show the date and time a patch was installed.
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
To fix this issue:
- Uninstall patch (control panel)
- Rerun SP3 for SQL 2008 R2
- Reinstall MS15-058
a. During the reinstall, make sure SQL Server is checked. If it is grayed out and won’t let you check the option after reinstalling SP3, try a SQL Repair. Once you do the repair, try installing the security patch again.
- Verify SQL shows the new version