Windows 10: Are you still running SQL Server 2005? Time to Upgrade.

  1. Brink's Avatar
    Posts : 33,151
    64-bit Windows 10 Pro build 18262
       14 Apr 2015 #1

    Are you still running SQL Server 2005? Time to Upgrade.

    Are you still running SQL Server 2005? We know itís hard to let go, but itís been 10 years. In its time SQL Server 2005 was a great choice for your departmental and mid-market IT needs. 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 to start planning.

    After 10 great years, extended support for all versions of SQL Server 2005 is coming to an end on April 12, 2016. A year sounds like plenty of time to plan your migration, but, depending on the type of application, the migration destination, the scale of the move and resources allocated, migrations can take several months. In addition to SQL Server 2005, you may have heard that support for Windows Server 2003 is ending soon. As you plan your SQL Server migration, you should also plan your infrastructure migration to get the most out of our modern platform. Planning now will ensure that you are able to make the move in time and Microsoft is here to help you in that process.

    First, it is important that you know what end of support means for your business. While SQL Server 2005 instances will continue to run, after the end of support date Microsoft will no longer provide hotfixes or security updates. Additionally, the benefits of upgrading to a modern data platform far outweigh the costs of maintaining security, support and compliance for an unsupported database.

    Upgrading is not just a maintenance task, but an opportunity to provide new value to your business. Moving to SQL Server 2014 or Azure SQL Database enables you to achieve breakthrough performance:

    • SQL Server 2014 has been benchmarked to be 13 times faster than SQL Server 2005, before the additional performance gains available from in-memory OLTP.
    • AlwaysOn availability groups provide more reliable High Availability.
    • Together with Windows Server 2012 R2 you can scale up across compute, networking and storage.
    • New tools in SQL Server Management Studio provide an easy on-ramp to cloud to help you get more from your data platform investment.

    You can read more about the benefits to planning for SQL Server 2005 and Windows Server 2003 end of support now. And learn about the quick ROI of SQL Server 2012 and 2014 in a study Microsoft commissioned with Forrester on the Total Economic Impact of SQL Server Ė read the full study or watch the webinar.

    Over the next year, the team will post a series of blogs around SQL Server 2005 end of support and information to help you in your upgrade path including topics on the process of upgrading, tools available to help you upgrade, migration destination guidance and more.

    To help you get started, Microsoft has put together several tools and resources to prepare for your upgrade:

    : Determine which applications are running on SQL Server 2005 and make the case for an upgrade.

    Target: Choose a migration on destination for each application whether on-premises, virtualized or in the cloud.

    Upgrade: Plan your upgrade, whether you do it yourself or collaborate with a partner.

    For more information on SQL Server 2005 end of support, visit us at
    Learn more about how Microsoft customers are already benefiting from upgrading and migrating to SQL Server 2014:

    • Stack Overflow uses SQL Server 2014 to provide reliable, high-performing technology to support its mission of providing lightning fast answers online.
    • Samsung Electro-Mechanics improved OLTP performance up to 24 times and DW up to 22 times when they upgraded to SQL Server 2014.
    • GE Healthcare delivers applications to healthcare providers worldwide using SQL Server 2014 and Microsoft Azure.
    • Callaway Golf reduced cost and improved scalability by moving servers to the cloud.
    Source: Are you still running SQL Server 2005? Now is the time to upgrade to a modern data platform - The Official Microsoft Blog
      My ComputersSystem Spec

  2. spapakons's Avatar
    Posts : 2,483
    Windows 10 Pro 64-bit 1803 (April 2018 build 17134.48)
       06 Jan 2016 #1


    I have an computer running my old ERP program which was based on Microsoft SQL Server 2005. After upgrading from Windows 8.1 32-bit to Windows 10 32-bit it has some difficulties connecting to the database and launching the ERP application (user not found in base error). How can I safely upgrade to Microsoft SQL 2014? I installed the Upgrade Advisor and got a report, how do I proceed with the upgrade? Could I just download the Microsoft SQL Express 2014 and install it? Anything else to do?

    Thank you in advance

    EDIT: Solved! Found the culprit!

    The computer has a small 80GB hard disk which was almost full with about 2-3GB free space. So I compressed the disk and now has about 15GB free. Except I unknowingly introduced an incompatibility! Microsoft SQL server doesn't work properly from a compressed folder. I had downloaded the Microsoft SQL Server 2014 Express and run it. Then I chose upgrade and it analyzed my current database before upgrading. Here was were I informed that I could not upgrade a compressed folder and was prompted to select another uncompressed folder. I immediately quitted the setup and proceeded to expand the "Microsoft SQL Server", "Microsoft SQL Server Compact Edition" folders and the EPR application folder. I restarted the computer and now it worked at once without any complain!

    So anybody else having problems connecting to your SQL database, first make sure the Microsoft SQL Server folder in Program Files and any other relevant folders are NOT compressed!

    Thank you for your time to read this.
    Last edited by spapakons; 06 Jan 2016 at 08:56.
      My ComputerSystem Spec


Related Threads
How to Synchronize Clock with an Internet Time Server in Windows 10 Your PC's clock is used to record the time whenever you create or modify files on your PC. You can change the clock's time and time zone. You can synchronize your PC's clock...
Solved Running 8.1Pro RTM, will I get the win10 upgrade? in Windows Updates and Activation
Right now I'm running an activated win8.1 pro RTM version of windows. Since I'm running RTM will I be able to upgrade to win10 for free? Thanks :)
N/B/running hot in Drivers and Hardware
My North Bridge is at 126%. It's on a Asus Crosshair IV Formula Motherboard Now this one I built for my boy and it sat lol for about a year. I'M RIDING IT NOW. Is that to hot for...
Read more: Windows Server 2016 leaks reveal Nano Server, protected VM role plans | ZDNet
Is your internet time off? Are you running Win10 E? Try changing to the second server on the list. It works!
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 14:32.
Find Us