Setup: Application server running Windows Server 2003 R2 Std., with Windows
Defender and Symantec Corporate Antivirus v10.2. Intent is to use this
server to host SharePoint Server 2007 Enterprise, with SQL Server 2005 as
the database.

How I got here: Had a BIG problem between SharePoint and SQL Server so I
did a complete uninstall of both, using Revo Uninstaller, then deleting all
leftover folders. I am trying to install SQL Server 2005, with SP's and all
required security updates, before I install SharePoint.

The Problem: I can install all components, except for the database
services. It gives me an error that "it can't start the service"
(elaborated below). I've tried 5-6 times over the last 9 hours to install
this. I've googled the errors, with no luck. They all seem geared toward
either SQL Server 2005 Express, or installing on Windows XP. I've tried
installing one component at a time, in various orders, same result.

I'm stumped (it doesn't help that I'm a SQL newbie in knowledge).

Here's the errors I'm seeing. Hope someone can help!

The lone Application Log entry:

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 11/10/2009
Time: 2:09:28 PM
User: <domain\user>
Computer: <server name>
Description:
The description for Event ID ( 10005 ) in Source ( MsiInstaller ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be
able to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event:
Product: Microsoft SQL Server 2005 -- 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 (1067) The process terminated unexpectedly.
.., (NULL), (NULL), (NULL), (NULL), , .

Data:
0000: 7b 31 33 30 41 33 42 45 {130A3BE
0008: 31 2d 38 35 43 43 2d 34 1-85CC-4
0010: 31 33 35 2d 38 45 41 37 135-8EA7
0018: 2d 35 41 37 32 34 45 45 -5A724EE
0020: 36 43 45 32 43 7d 6CE2C}
===================
This is from C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG:

2009-11-10 14:08:39.83 Server Microsoft SQL Server 2005 - 9.00.1399.06
(Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

2009-11-10 14:08:39.83 Server (c) 2005 Microsoft Corporation.
2009-11-10 14:08:39.83 Server All rights reserved.
2009-11-10 14:08:39.83 Server Server process ID is 716.
2009-11-10 14:08:39.83 Server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-11-10 14:08:39.83 Server Registry startup parameters:
2009-11-10 14:08:39.83 Server -d C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-11-10 14:08:39.83 Server -e C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-11-10 14:08:39.83 Server -l C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-11-10 14:08:39.83 Server Command Line Startup Parameters:
2009-11-10 14:08:39.83 Server -m SqlSetup
2009-11-10 14:08:39.83 Server SqlSetup
2009-11-10 14:08:39.83 Server -Q
2009-11-10 14:08:39.83 Server -q SQL_Latin1_General_CP1_CI_AS
2009-11-10 14:08:39.83 Server -T 4022
2009-11-10 14:08:39.83 Server -T 3659
2009-11-10 14:08:39.83 Server -T 3610
2009-11-10 14:08:39.83 Server -T 4010
2009-11-10 14:08:39.86 Server SQL Server is starting at normal priority
base (=7). This is an informational message only. No user action is
required.
2009-11-10 14:08:39.86 Server Detected 2 CPUs. This is an informational
message; no user action is required.
2009-11-10 14:08:39.89 Server Set AWE Enabled to 1 in the configuration
parameters to allow use of more memory.
2009-11-10 14:08:40.09 Server Using dynamic lock allocation. Initial
allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is
an informational message only. No user action is required.
2009-11-10 14:08:40.12 Server Attempting to initialize Microsoft
Distributed Transaction Coordinator (MS DTC). This is an informational
message only. No user action is required.
2009-11-10 14:08:42.22 Server Attempting to recover in-doubt
distributed transactions involving Microsoft Distributed Transaction
Coordinator (MS DTC). This is an informational message only. No user action
is required.
2009-11-10 14:08:42.33 Server Database Mirroring Transport is disabled
in the endpoint configuration.
2009-11-10 14:08:42.51 spid5s Warning ******************
2009-11-10 14:08:42.51 spid5s SQL Server started in single-user mode.
This an informational message only. No user action is required.
2009-11-10 14:08:42.70 spid5s Starting up database 'master'.
2009-11-10 14:08:43.31 spid5s Recovery is writing a checkpoint in
database 'master' (1). This is an informational message only. No user action
is required.
2009-11-10 14:08:44.22 spid5s SQL Trace ID 1 was started by login "sa".
2009-11-10 14:08:44.48 spid5s Starting up database
'mssqlsystemresource'.
2009-11-10 14:08:45.47 spid5s Error: 15209, Severity: 16, State: 1.
2009-11-10 14:08:45.47 spid5s An error occurred during encryption.
2009-11-10 14:08:45.69 spid5s SQL Trace was stopped due to server
shutdown. Trace ID = '1'. This is an informational message only; no user
action is required.
====================================
This is from the Summary.txt file:

Machine : <server name>
Product : SQL Server Database Services
Error : 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."
--------------------------------------------------------------------------------
Machine : <server name>
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_<server name>_SQL.log
Last Action : InstallFinalize
Error String : 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 (1067) The process terminated unexpectedly.
Error Number : 29503
--------------------------------------------------------------------------------
==================================================

And this is the tail-end of the SQLSetup0001_<server name>_SQL.log file:

Property(S): ProductToBeRegistered = 1
MSI (s) (E48) [14:09:58:820]: Note: 1: 1708
MSI (s) (E48) [14:09:58:820]: Product: Microsoft SQL Server 2005 --
Installation failed.

MSI (s) (E48) [14:09:58:820]: Windows Installer installed the product.
Product Name: Microsoft SQL Server 2005. Product Version: 9.00.1399.06.
Product Language: 1033. Installation success or error status: 1603.

MSI (s) (E48) [14:09:58:835]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (E48) [14:09:58:835]: MainEngineThread is returning 1603
MSI (s) (E4:A0) [14:09:58:945]: No System Restore sequence number for this
installation.
=== Logging stopped: 11/10/2009 14:09:58 ===
MSI (s) (E4:A0) [14:09:58:945]: User policy value 'DisableRollback' is 0
MSI (s) (E4:A0) [14:09:58:945]: Machine policy value 'DisableRollback' is 0
MSI (s) (E4:A0) [14:09:58:945]: Incrementing counter to disable shutdown.
Counter after increment: 0
MSI (s) (E4:A0) [14:09:58:945]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Curr entVersion\Installer\Rollback\Scripts
3: 2
MSI (s) (E4:A0) [14:09:58:945]: Note: 1: 1402 2:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Curr entVersion\Installer\Rollback\Scripts
3: 2
MSI (s) (E4:A0) [14:09:58:945]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (E4:A0) [14:09:58:945]: Restoring environment variables
MSI (c) (34:2C) [14:09:58:945]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (34:2C) [14:09:58:960]: MainEngineThread is returning 1603
=== Verbose logging stopped: 11/10/2009 14:09:58 ===
==============================

If it helps, I've reinstalled Windows Installer 4.5 several times - no
change.

Any ideas out there?
--
Mike Webb
Platte River Whooping Crane Maintenance Trust, Inc.
a conservation non-profit (501 (c)(3)) organization
Wood River, NE

Hi Mike,
What is the SQL Server service account specified during your setup? Please
try using Local System as the service account and see if this happens
again. From the error message, it looks that the service account has not
enough permission to start your SQL Server.

If this issue persists, please temporarily disable Windows Defender on your
Windows Server 2003 and see if it helps.

Best regards,
Charles Wang

It's a Domain User account that is also part of the Local Administrators
group. I'll try your idea and report back.

""Charles Wang [MSFT]"" <changliw (AT) online (DOT) microsoft.com> wrote

That was the answer! Thanks!

Mike

""Charles Wang [MSFT]"" <changliw (AT) online (DOT) microsoft.com> wrote

I'm interested. Was the solution to disable windows defender or to install as
local system?

Thanks
Frede

"Mike in Nebraska" wrote: