Hello MSSQL2008 users
I have installed CTP versions and RC0 (Release Candidate) versions of Microsoft SQL Server 2008 before it is released for RTM version.
Since I'm running about 3 or 4 SQL Server database instances on my development computer, although their services are stopped, I began sufferring from performance on my computer. So I decided uninstalling the CTP and RC0 editions of MS SQL Server 2008 (Katmai).
When I tried to start the service of the MS SQL Server 2008 CTP6 version, I got the following error message:
Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17051.
As the error message is directing me to the System Event Logs, I opened the Event Viewer application and found the following entry in the System Event logs:
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 8/27/2008
Time: 9:59:13 AM
User: N/A
Computer: ISTW1849
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error 17051 (0x429B).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I then checked the installation folder for the service in order to find out any clue for the error in the ERRORLOG file.
I found my database instance ERRORLOG file in folder "C:\Program Files\Microsoft SQL Server CTP6\MSSQL10.MSSQLSERVERCTP6\MSSQL\LOG".
Be ready for the shocking :) situation. What I found about the error in the ERRORLOG file is :
2008-08-27 09:59:12.89 Server Microsoft SQL Server code name "Katmai" (CTP) - 10.0.1300.13 (Intel X86)
Feb 8 2008 00:06:52
Copyright (c) 1988-2007 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2008-08-27 09:59:12.89 Server (c) 2005 Microsoft Corporation.
2008-08-27 09:59:12.89 Server All rights reserved.
2008-08-27 09:59:12.89 Server Server process ID is 4104.
2008-08-27 09:59:12.89 Server Authentication mode is MIXED.
2008-08-27 09:59:12.89 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server CTP6\MSSQL10.MSSQLSERVERCTP6\MSSQL\LOG\ERRORLOG'.
2008-08-27 09:59:12.95 Server Error: 17051, Severity: 16, State: 1.
2008-08-27 09:59:12.95 Server SQL Server evaluation period has expired.
So the reason for the error 17051 is just beacuse of the SQL Server evaluation period has expired.