Support for SQL Server 2005 ends this week - are you ready?

At this late hour, the key is to minimize your exposure

Tomorrow marks the end of support for Microsoft SQL Server 2005, and that means companies relying on it are just about out of time. There will be no more updates from Microsoft, so staying with the software could open you up to a host of risks.

Microsoft encourages users to move to SQL Server 2014 or Azure SQL Database, but those aren't the only options. Either way, the transition is going to take some time. If you haven't already been working on it, the most important thing now is to act quickly to minimize the amount of time your company is left exposed.

"The biggest risk stems from continuing to use the product when there is any kind of uncontrolled or external access to that database," said Tim Hegedus, senior manager of the analyst team with Miro Consulting. "Any security breach can be damaging not just monetarily but also reputationally."

Compliance problems can also be a result for organizations in financial services and other industries where regulations require the use of supported software, noted David Mayer, vice president of product management for software with Insight.

Unfortunately, upgrading SQL Server is typically not a matter of simply plugging in the new version; the apps built on the database can be the much bigger challenge. They may need to be reconfigured or upgraded as well, Mayer explained.

Organizations that haven't planned ahead for Tuesday should begin by assessing their legal, financial and reputational exposure, Hegedus said.

Emergency funds for the project may have to be found.

Companies should also look closely at all deployments and classify them into one of the following categories: 1) purely internal and not needing any action; 2) requiring an upgrade; or 3) needing some level of additional support from Microsoft, he said.

"My guess is that it will be some combination of at least two of those for the majority of companies," he said.

Mayer encourages companies to consider the cloud-based Azure option seriously.

"Not only is this an excellent opportunity to dip into the Azure pool, but it solves the problem quickly and easily," he explained. "Instead of buying a new server, installing a bunch of software and then moving the data, an Azure SQL VM can be spun up in just a few minutes."

Microsoft offers an open-source migration tool to help companies taking that route.

Whatever you do, the project clearly needs to be a priority for IT.

"IT is all about competing priorities, and triaging IT projects has become an art form," Mayer said.

Looking ahead, "don’t go through this again," he urged. "SQL 2008 goes off support in July 2019. Start looking at instances of SQL 2008 now to give yourself plenty of time."

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Microsoft

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Katherine Noyes

IDG News Service
Show Comments

Father’s Day Gift Guide

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Laura Johnston

MSI GS65 Stealth Thin

If you can afford the price tag, it is well worth the money. It out performs any other laptop I have tried for gaming, and the transportable design and incredible display also make it ideal for work.

Andrew Teoh

Brother MFC-L9570CDW Multifunction Printer

Touch screen visibility and operation was great and easy to navigate. Each menu and sub-menu was in an understandable order and category

Louise Coady

Brother MFC-L9570CDW Multifunction Printer

The printer was convenient, produced clear and vibrant images and was very easy to use

Edwina Hargreaves

WD My Cloud Home

I would recommend this device for families and small businesses who want one safe place to store all their important digital content and a way to easily share it with friends, family, business partners, or customers.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?