SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.

Software Development



The SQL Server (MSSQLSERVER) service terminated with service-specific error 17051 (0x429B)

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.

Published Wednesday, August 27, 2008 10:10 AM
Filed Under: , , ,

Comments

No Comments
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems