Failed to install SQL Server 2005 Enterprise (x86) on one server

Failed to install SQL Server 2005 Enterprise (x86) on one server

I am trying to install SQL Server 2005 Enterprise on one of my test server. I am sure I entered the correct domain user name and password and the account is admin. I’ve tried several times but I got this error instantly:

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."

Some of the other component could be installed properly. The system was just rebuilt with only VSTS 2005 installed.

Here is the part of the log

…

MSI (s) (48:58) [06:04:54:365]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])

MSI (s) (48:58) [06:04:54:365]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)

MSI (s) (48:CC) [06:04:54:365]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIE56.tmp, Entrypoint: Do_sqlScript

<Func Name='LaunchFunction'>

Function=Do_sqlScript

<Func Name='GetCAContext'>

<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>

Doing Action: Do_sqlScript

PerfTime Start: Do_sqlScript : Thu Jul 12 06:04:54 2007

Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jul 12 06:04:54 2007

Unable to start service (1069)

Error Code: 0x8007042d (1069)

Windows Error Text: The service did not start due to a logon failure.

Source File Name: sqlsetuplib\service.cpp

Compiler Timestamp: Fri Sep 16 13:20:12 2005

Function Name: sqls:ervice:tart

Source Line Number: 316

…

Thanks - Andy

Seems I have found the root cause. I changed starting the service using local system user and it works. I remember I installed SQL Server 2005 on another machine using the same way it works for me, very weird.