So I am being asked to support a SQL Server 2008 R2 Express, in looking at the discovery report I believe I am on the core product (10.50.1600.1) and that the previous admin has not applied any of the service packs. Since the box is seeing a login storm as noted in this tech note - https://connect.microsoft.com/SQLServer/feedback/details/435782/sever-login-failure-storm-for-sql-server-2008-x64-sql-service-account
I want to update the box.
SP4 appears to be the current service pack and based on the quote "service packs are cumulative updates" . I plan on just installing SP 4, but wanted to see if anyone had any issues following this approach. https://support.microsoft.com/en-us/kb/2979596
Thank for any feedback / advice.