October 11, 2008 05:54am pdt

My Account

Top 15 Experts

Overall Top Experts

1angelIII 3,116,367
2chapmandew 2,425,075
3aneeshatti... 1,124,816
4mark_wills 582,337
5ptjcb 545,683
6Yveau 539,545
7dtodd 466,526
8dqmq 421,861
9PFrog 404,802
10BrandonG... 372,667
11appari 367,298
12imitchie 348,938
13acperkins 325,363
14ee_rlee 324,111
15momi_sa... 285,172

	[x] Attachment Details

SQL 2005 Express install fails on service start

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.6

Zones: SQL Server 2005, MS SQL Server

Tags: sql, error, server, service, express

I am trying to install SQL 2005 Express on Windows 2003 R2. The install fails at the end when it is trying to start the services and the install complete fails.
In the event log I get:The SQL Server (SQLEXPRESS) service terminated with service-specific error 1814 (0x716)
In the setup log I see:
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS

Error Code: 1814
MSI (s) (08!60) [17:28:36:234]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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 error is (1814) The specified resource name cannot be found in the image file.
.

Error 29503. 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 error is (1814) The specified resource name cannot be found in the image file.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Thu Feb 15 17:28:36 2007
Service MSSQL$SQLEXPRESS with parameters '-d"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\master.mdf" -l"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data\mastlog.ldf" -m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Feb 15 17:28:36 2007
Service failed unexpectedly (1814)
Error Code: 0x80070716 (1814)
Windows Error Text: The specified resource name cannot be found in the image file.
Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Wed Oct 26 16:37:52 2005
Function Name: sqls::Service::Start
Source Line Number: 301

Any ideas what is making this fail?

	#	Title
	1	how to use MSSql instead of SQLExpr…
	2	SQLExpress 2005 Deadlocks
	3	Running DTSX packages on SQLExpress
	4	Simplest MSI installer that installs MS S…
	5	SQLExpress
	6	SQLExpress