And Event Viewer Says…

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: —
Time: —
User: N/A
Computer: —
Description: The SQL Server (<instance_name>) service terminated with service-specific error 17051 (0x429B).

So then I scurry on over to find out what the SQL Server logs are saying about all of this.  I go here: C:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Log and open the ERROR file.

And the ERROR File Says…

…blah, blah, blah…

2011-02-18 11:16:40.77 Server      Error: 17051, Severity: 16, State: 1.
2011-02-18 11:16:40.77 Server      SQL Server evaluation period has expired.

How to Upgrade the Instance with Product Key Information

We are a participant of Microsoft’s Software Assurance program thus we have licenses for SQL Server 2008 Standard edition at the ready.  This particular database server has 2 instances installed on it.  One of the instances is OK but one of them is not.  So I simply need to upgrade the appropriate instance with the product key and that should resolve it.  Here’s how to do it.

  1. Insert the SQL Server 2008 installation media in the drive and launch setup.exe.
  2. Select Maintenance in the left navigation menu and Edition Upgrade on the right.
  3. Go through the wizard being sure to enter the correct product key.  Since I had already entered one for the first instance, the product key box was already populated with the correct one.
  4. At the Select Instance step select the appropriate instance to upgrade and Next all the way through hitting the Upgrade button to start the process.

Once the upgrade is complete, you should then be able to start the instance of the SQL Server service without error.

A Few Screenshots

SQL Server 2008 Edition Upgrade

Upgrade SQL Server 2008

SQL Server 2008 Upgrade Select Instance

Upgrade Select Instance