You are currently offline, waiting for your internet to reconnect

You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Bug #: 417649 (SQLBUDT)
SYMPTOMS
Consider the following scenario. An installation of Microsoft SQL Server 2005 Evaluation Edition has expired. You try to upgrade the installation to a retail version of SQL Server 2005. In this scenario, you receive the following error message, and then the installation fails:
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The following error messages are logged in the installation log file:
2007-08-16 16:29:50.10 Server Error: 17051, Severity: 16, State: 1.
2007-08-16 16:29:50.10 Server SQL Server evaluation period has expired.
Additionally, you notice that the following event is logged in Event Viewer:
Event Type: Error
Event Source: InstanceName
Event Category: (2)
Event ID: 17015
Date: Date
Time: Time
User: N/A
Computer: ComputerName
Description:
SQL Server evaluation period has expired.

For more information, see Help and Support Center at
http://support.microsoft.com
Note InstanceName represents the name of the instance that you installed. For the default instance, the instance name is MSSQLSERVER. Date and Time represent the date and the time when the installation failed. ComputerName represents the name of the computer.
CAUSE
This problem occurs because the Setup program cannot start the SQL Server service. When you install retail versions of SQL Server 2005, the Setup program tries to start the SQL Server service of the old installation of SQL Server 2005 Evaluation Edition. However, the service cannot start because the installation is expired. Therefore, the installation stops, and you receive the error messages.
WORKAROUND
To work around this problem, you must uninstall SQL Server 2005 Evaluation Edition. Then, install the retail version of SQL Server 2005. If you want to keep system databases and reuse the databases after a new installation, you can uninstall SQL Server 2005 at the command prompt by using the SAVESYSDB parameter. Then, install the retail version of SQL Server 2005 at the command prompt by using the USESYSDB parameter.

When SQL Server 2005 Evaluation Edition is expired, you cannot start the SQL Server service. If you want to move the user database to the retail version of SQL Server 2005, you can copy the user database files to a specified location. Then, you can attach the database to the retail version of SQL Server 2005.

For more information about how to install SQL Server 2005 at the command prompt, visit the following Microsoft Developer Network (MSDN) Web site:
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 914158 - Last Review: 09/22/2006 01:55:12 - Revision: 3.1

Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbsql2005setup kbtshoot kbexpertiseadvanced kbprb KB914158
Feedback
PV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" dex" class="col-sm-6 col-xs-24 ng-scope"> España - Español
Paraguay - Español
Venezuela - Español
tyle="display: none; " src="https://c1.microsoft.com/c.gif?DI=4050&did=1&t=">andom() * 16).toString(16); })).replace("R", (8 | Math.floor(Math.random() * 3)).toString(16)); var m = document.createElement("meta"); m.content = guid; m.name = "ms.dqid"; document.getElementsByTagName("head")[0].appendChild(m); >>