For the last service packs of SQL Server 2012 (15.64%), 2008 R2 (12.30%), and 2008 (4.30%) Microsoft still offers extended security updates. For SQL Server 2014 (by far the most popular version with 21.94% of installations) and SQL Server 2016 (14.34%) that is service pack 3. The 2 latest releases, SQL Server 2019 (12.77%) and SQL Server 2017 (12.65%) are still completely supported, while all other releases still have either supported service packs or extended security updates, for those that have opted into that. Only 6.07% of SQL Server installations are of the completely out of support SQL Server 2005 or SQL Server 2000. At first glance, the numbers don't look too bad. Lansweeper recently took a closer look at over 1.1 million SQL servers across more than 35,000 organizations.

The SQL server service packs is the percentage of SQL Server installations that are supported/EOL based on the SQL Server version and Service pack. 43.03% of SQL Server Installations Are No Longer Supported.

These risks will only grow over time, so it's vital you take action. If you're using any of these products and do nothing, it's almost certain that your risks around security and compliance will increase, which may also impact productivity. Once a product reaches its 'Extended Support End Date' there will be no patches, security updates or support from Microsoft. All warranty claims end and they will no longer accept feature and change requests. Why should I care?Īt the end of mainstream support, Microsoft will no longer provide non-security hotfixes unless you have an extended support agreement. Each version of SQL Server usually has both an end of support date and an end of extended support date. Microsoft outlines the end-of-life dates for all of their products to make customers aware of when they will cease support for specific products. But no worries because we got you covered with this guide. And soon, a few SQL Server versions will go End of Life. As its name suggests, it is used to manage the databases you use for your business.

SQL Server and SQL Server Compact is Microsoft's relational database management system (RDMS) application.

Sql server 2012 express sp2 upgrade