Upgrade from Microsoft SQL Server 2005 & Windows Server 2003

Are you still using your 2005 2G Nokia, Motorola RAZR flip or PalmOne Treo phone? Are you still using the laptop you purchased in 2003? Are you still using an iPod? Are you playing games on a PlayStation 2? Do you still carry a pager? Of course not! Then why are you still running Microsoft Server 2003 and/or SQL 2005 in the year 2016?

Microsoft support for SQL Server 2005 ends in April 2016, don’t forget that support for Windows Server 2003 ended on July 14, 2015.

How big is this issue?

  • A study by Softchoice found that 21 percent of servers were still using Server 2003 in the first half of 2015.
  • CloudPhysics reported similar numbers in June 2015 saying 18 percent of Windows Server virtual machines are running on Windows 2003.
  • An end-of-life survey by Bit9 found that 30 percent of enterprises surveyed plan to run Server 2003 after EOL support.
  • Netcraft's July 2015 Web Server Survey found 175 million web sites are served directly from Windows Server 2003 servers. These account for more than one fifth of all web sites in the survey.
  • What about SQL 2005? Kuba Stolarski from IDC said in a statement, "We estimate there are approximately 800,000 servers globally still running SQL Server 2005.”

As you can see, by the number of servers still running Windows Server 2003 and/or SQL 2005, it’s a big issue. This is a great opportunity to upgrade to Windows Server 2012 R2 and SQL Server 2014.

Microsoft Windows Server 2003

Microsoft will no longer issue security updates for any version of Windows Server 2003. If you are still running Windows Server 2003 in your data center, you need to take steps now to plan and execute a migration strategy to protect your infrastructure. By migrating to Windows Server 2012 R2, you can achieve concrete benefits, including improved performance, reduced maintenance requirements and increased agility and performance.

Key Concerns with Continuing to run Windows Server 2003

  • No patches/updates/non-security fixes.
  • Elimination of security fixes.Customers see security fixes as being among the most critical fixes for their installed servers.
  • Lack of support. Customers no longer have the ability to contact Microsoft for technical support in the event of a server problem.
  • Application support challenges. Application ISVs dislike having a complex support matrix and typically support current versions along with a finite number of earlier editions of the product.
  • Compliance issues. Customers in regulated industries or handling regulated data.
  • Inability to leverage modern cloud options from Microsoft and other vendors.

Windows Server 2012 improvements

Several upgrades were made from 2003 to 2008, but at this time you should move straight to 2012 R2, which includes the 2008 improvements and the new 2012 release that that brought forward a truly mature hypervisor and serious support for cloud-based deployments.

A few 2012 improvements over 2003 include:

  • Hyper-V
  • Improved system scale
  • DirectAccess
  • Improved server management, remote desktop services, remote infrastructure and web platform
  • Manageability through PowerShell
  • East of access
  • Virtualized data center
  • SMB 3.0

Microsoft SQL Server

After 10 years, extended support for all versions of SQL Server 2005 is coming to an end on April 12, 2016. Over the last decade, Microsoft has continued to invest and SQL Server has evolved to be an enterprise-class solution to support your growing business needs. If you haven’t yet moved on to take advantage of these capabilities, now is the time.

While SQL Server 2005 will continue to run, after the end-of-support date, Microsoft will no longer provide hot fixes or security updates. The benefits of upgrading to a modern SQL 2014 data platform far outweigh the costs of maintaining security, support and compliance for an unsupported database.

Below are a few benefits to upgrading to SQL 2005 beyond maintenance and security updates:

  • Maintain compliance – It will become harder to prove compliance with the latest regulations.
  • Achieve breakthrough performance – Per industry benchmarks, SQL 2014 delivers up to 13x performance gains relative to SQL 2005.
  • Virtualize and consolidate with Windows Server – Scale up on-premises or scale out via private cloud. Reduce costs by consolidating more database workloads on fewer servers, and increase agility using the same virtualization platform on-premises and in the cloud.
  • Reduce TCO and increase availability – Reduce the total cost of ownership of deployment, management and maintenance of your enterprise database applications.
  • Easy on-ramp to cloud for web applications – Get enhanced compatibility with SQL Server makeing it easier than ever to migrate from SQL Server.
  • Get more from your data platform investments – Upgrading and migrating databases doesn’t have to be painful. A Forrester Total economic Impact of MS SQL study found a payback period of just 9.5 months for moving to SQL Server 2012 or 2014.

Microsoft SQL Solutions from Lenovo

The Microsoft Data Warehouse Fast Track (DWFT) for SQL Server 2014 Program is designed to reduce the time that is necessary for enterprise leaders to build configurations that solve data warehousing issues. Lenovo teamed with Microsoft to create DWFT solutions for Microsoft SQL Server, by using various System x servers to cover a wide range of data warehouse sizes. These solutions are designed to help companies with various data warehousing needs to rapidly deploy and implement data warehouse solutions.

The Microsoft DWFT program makes it easy for IT leaders to reduce cost, save time and alleviate risk with reliable, pretested hardware and documented preferred practices for data warehousing.

These solutions help in delivering the following benefits:

  • Improved time to value with pretested hardware configurations.
  • Reduced hardware testing requirements and less need for immediate tuning.
  • Reduced TCO, thanks to better price and performance, rapid deployment and certified performance rating from Microsoft and Lenovo.
  • Optimized performance with pretested System x hardware configurations.

Further Information:

For information, please visit Windows Server 2012 R22003 End of SupportMicrosoft SQL Server and Microsoft Solution on Lenovo Servers.