On July 9, 2019, Microsoft will be ending extended support for SQL Server 2008 and 2008 R2. This means they’ll stop providing tech support and security updates for those versions of SQL Server. Unresolved vulnerabilities will remain that way once that date hits, posing a security risk to programs using either version.
What does this have to do with Microsoft Access? And what exactly is SQL Server, anyway?
SQL Server is Microsoft’s database management system. Many applications use SQL Server to manage the database driving the program. It’s a common practice for applications built in Microsoft Access to use SQL Server as their database engine. So, an Access application which uses SQL Server 2008 or 2008 R2 will become vulnerable when support ends.
How can I tell if I’m using SQL Server 2008 or 2008 R2?
Either on your computer or your server, open the start menu and go to control panel -> programs and features. Scroll down and look for “Microsoft SQL Server 2008 (32-bit)”. It may say Server 2008 R2, and it may say (64-bit), but in any of these cases, it indicates you have an affected version of SQL Server installed.
What should I do?
Upgrading SQL Server to 2014 or newer will keep the application in mainstream support with Microsoft, but upgrading SQL Server isn’t a minor update. If you need help applying this update, or are unsure if you need it, contact us at 610-260-0300.