End of Life Support Date for Microsoft Products Affecting Keynetix Software
In the next few months, Microsoft are retiring extended support for both Windows 7 and the SQL Server 2008 and SQL Server 2008 r2 versions. For users who initially installed HoleBASE SI before 26th September 2014 (Versions less than 1.22.0.x) and users who installed KeyLAB before the start of 2015 and who haven’t already upgraded should particularly check to ensure that they are not affected.
The end of extended support dates are listed below.
|Client Operating Systems||End of Mainstream Support||End of Extended Support|
|Windows 7, service pack 1*||January 13, 2015||January 14, 2020|
Microsoft SQL Server 2008 and SQL Server 2008 r2
|Products Released||Lifecycle Start Date||Mainstream Support End Date||Extended Support End Date|
|SQL Server 2008||November 11th 2008||July 8th 2014||July 9th 2019|
|SQL Server 2008r2||July 20th 2010||July 8th 2014||July 9th 2019|
How do I find out what version I am running?
To find out what version of Microsoft Windows you are running, hold down the windows key and press R, this will open the program run box, type in ‘winver’ (without the quotes) and press OK. A properties box should then appear telling you what version you currently have installed.
To find out what version of SQL Server you are running, you will need to browse through to the following location.
- C:\Program Files\Microsoft SQL Server
Within here, you should see a number of folders in the format MSQLXX.XXXX, simply look for the leading numbers after the MSSQL part of the folder name. The following numbers correlate to the SQL Server version.
- 8.0 for SQL Server 2000
- 9.0 for SQL Server 2005
- 10.0 for SQL Server 2008
- 10.5 for SQL Server 2008 R2
- 11.0 for SQL Server 2012
- 12.0 for SQL Server 2014
- 13.0 for SQL Server 2016
- 14.0 for SQL Server 2017
Note that if you are running a networked version of SQL than you will need to ask your IT, or someone with server access to check the above.
What does this mean for me and my organisation?
Users who are using either of the systems mentioned above should consider upgrading to a newer version as soon as possible to ensure that the updates Microsoft supply to ensure that your system is secure and able to work as efficiently as possible. After the deadline date above, Microsoft will no longer be providing updates to the relevant systems meaning that your systems may be vulnerable to security issues.
If you decide not to upgrade and stay on the older versions of the relevant system, your systems should carry on working without issue, however we strongly recommend upgrading to ensure that your systems are protected from security issues and that they continue to receive further updates from Microsoft.
What can I upgrade to?
We currently support the following versions of Microsoft Windows following the end of extended support date.
- Windows 8.1
- Windows 10
We currently support the following versions of Microsoft SQL Server following the end of extended support date.
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
For more information on the different versions of SQL Server, see the following page from Microsoft.
How do I Upgrade?
To upgrade your version of Microsoft Windows, we recommend speaking with your IT department to find out the best route for you and your organisation. This may be as simple as running an update to update your operating system or may require a fresh install depending on your licence situation and other factors.
To upgrade your version of SQL Server, we first recommend that a full backup is undertaken on the databases that will be affected. Once this has been done, the databases can either be upgraded by using the SQL Server Setup application or a new version can be installed and then the databases restored. For more information see the following Microsoft support article;
We strongly recommend that your SQL Server upgrades are handled by your IT departments or other IT professionals. If this is not possible, or if more information is needed, we recommend you to contact our support team at firstname.lastname@example.org where they will be able to guide you further.
For more information, please see the following two links from Microsoft.
Tuesday 27 August 2019
Thursday 13 June 2019
Tuesday 30 April 2019
Tuesday 16 April 2019
Monday 18 March 2019