SQL Server – Startup – Error – SQL Server evaluation period has expired.

Background

SQL Server is no longer coming up on my development box.  And, so what to do but repair the install.

But, even that failed.

 

SQL Server Installation repair

Here is the journal from trying a repair.

Complete with failures

CompleteWithFailure

 

Review Summary Log

Text


  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x851A0019
  Error description:             Could not find the Database Engine startup handle.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.4213.0&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4025


Pertinent Info

  1. Component Error Code :- 0x851A0019
  2. Error description :- Could not find the Database Engine startup handle

 

Diagnostic

So it looks like we are not able to start the “Database Engine“.

 

Took to Net

Took to the Net and found a nice post:

SQL Server Troubleshooting: Could Not Find Database Engine Startup Handle Error During installation

The relevant section is :

Looking at SQL Server Error Log
Even after following above method if you still get the error this means that problem is not with SQL Server installation something different is blocking SQL Server installation. The important point to note here with such error is you will see SQL Server installed but the services are not online( there might be few exception). Please check SQL Server configuration manager and Services.msc to check whether SQL Server services are present or not. If they are present but in stopped state you must look at logfile present at location.

Start

Start from Services Applet

Let us to start through the Services Applet.

ServiceSpecificErrorCode17051

Not much help.

Start from Command Line

Need more help and so launched Command Prompt.

Command


CD /D D:\Program Files\Microsoft SQL Server\MSSQL12.V2014\MSSQL\Binn

sqlservr.exe -sV2014

Response



2016-03-01 17:32:15.47 Server      Microsoft SQL Server 2014 - 12.0.4213.0 (X64)

        Jun  9 2015 12:06:16
        Copyright (c) Microsoft Corporation
        Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 76
01: Service Pack 1)

2016-03-01 17:32:15.48 Server      UTC adjustment: -8:00
2016-03-01 17:32:15.48 Server      (c) Microsoft Corporation.
2016-03-01 17:32:15.48 Server      All rights reserved.
2016-03-01 17:32:15.48 Server      Server process ID is 2336.
2016-03-01 17:32:15.48 Server      System Manufacturer: 'Hewlett-Packard', Syste
m Model: 'HP Z200 Workstation'.
2016-03-01 17:32:15.48 Server      Authentication mode is MIXED.
2016-03-01 17:32:15.48 Server      Logging SQL Server messages in file 'D:\Progr
am Files\Microsoft SQL Server\MSSQL12.V2014\MSSQL\Log\ERRORLOG'.
2016-03-01 17:32:15.48 Server      The service account is 'LAB\dadeniji'.
This is an informational message; no user action is required.
2016-03-01 17:32:15.48 Server      Registry startup parameters:
         -d D:\Program Files\Microsoft SQL Server\MSSQL12.V2014\MSSQL\DATA\master.mdf
         -e D:\Program Files\Microsoft SQL Server\MSSQL12.V2014\MSSQL\Log\ERRORLOG
         -l D:\Program Files\Microsoft SQL Server\MSSQL12.V2014\MSSQL\DATA\mastlog.ldf
2016-03-01 17:32:15.48 Server      Command Line Startup Parameters:
         -s "V2014"
2016-03-01 17:32:15.70 Server      Error: 17051, Severity: 16, State: 1.
2016-03-01 17:32:15.70 Server      SQL Server evaluation period has expired.
2016-03-01 17:32:15.70 Server      SQL Server shutdown has been initiated



Remediation

In our case, we were running the evaluation edition and it is now time to upgrade it.

The steps to remediate is:

  1. Get SQL Server Setup
  2. From the left panel, choose Maintenance
  3. On the right panel, choose Edition Upgrade
  4. In the Product Key panel, enter your Product Key
  5. In the License Terms panel, agree to the terms
  6. In the Select Instance panel, choose the Instance
  7. Review your choices and confirm in the “Ready to Upgrade Edition” panel

 

Maintenance

Maintenance

Product Key

ProductKey

Product Key – Filled

ProductKey-Filled-Brushed

License Terms

LicenseTerms-Revised

Select Instance

SelectInstance

Ready To Upgrade

ReadyToUpgrade

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s