I am not able to install SQL Server 2005 x86 DEV on Windows 7 Pro 64bit

I had a working copy of SQL Server 2005 x86 DEV on my Windows 7 laptop. For some reason I had to uninstall it and now I am not able to install it again.

I am aware of the fact the I am not supposed to start the server service before applying SP3 or higher. So I keep the start server and the end check box unchecked. However during the installation there comes a point were the installer try to start the service (even if the flag was unchecked). After taking around 10 minutes or so it report an error that it can't start the service. And the eventually I need to cancel the installation.  The net result is missing SQL server.

Can someone provide me with a fix. (I can't use a different version of OS or SQL Serer)

August 2nd, 2013 3:12pm

Hello,

Please share the Summary.txt log file with us. The following article may help you locate the file on disk:

http://msdn.microsoft.com/en-US/library/ms143702(v=sql.90).aspx

Did you try to run setup with the Run as Administrator option? Does the Windows account use to run SQL Server setup has the following user rights?

http://support.microsoft.com/kb/2000257


Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2013 5:27pm

Here is my Summary.txt

Microsoft SQL Server 2005 9.00.1399.06 
============================== 
OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600) 
Time            : Fri Aug 02 13:28:58 2013 
 
SAM-PC : Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
Machine         : SAM-PC 
Product         : Microsoft SQL Server Setup Support Files (English) 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLSupport_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server Native Client 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLNCLI_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft Office 2003 Web Components 
Product Version : 11.0.6558.0 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_OWC11_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server 2005 Backward compatibility 
Product Version : 8.05.1054 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_BackwardsCompat_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : MSXML 6.0 Parser 
Product Version : 6.00.3883.8 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_MSXML6_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server Setup Support Files (English) 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLSupport_2.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server Native Client 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLNCLI_2.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft Office 2003 Web Components 
Product Version : 11.0.6558.0 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_OWC11_2.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server VSS Writer 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SqlWriter_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server 2005 Backward compatibility 
Product Version : 8.05.1054 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_BackwardsCompat_2.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : MSXML 6.0 Parser 
Product Version : 6.00.3883.8 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_MSXML6_2.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server Setup Support Files (English) 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLSupport_3.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server Native Client 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_SQLNCLI_3.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft Visual Studio 2005 Premier Partner Edition - ENU 
Product Version : 8.0.50727.42 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_PPESku_1.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft Office 2003 Web Components 
Product Version : 11.0.6558.0 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_OWC11_3.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server 2005 Backward compatibility 
Product Version : 8.05.1054 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_BackwardsCompat_3.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : MSXML 6.0 Parser 
Product Version : 6.00.3883.8 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_MSXML6_3.log 
-------------------------------------------------------------------------------- 
Machine         : SAM-PC 
Product         : Microsoft SQL Server 2005 Integration Services 
Product Version : 9.00.1399.06 
Install         : Successful 
Log File        : C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SAM-PC_DTS.log 
-------------------------------------------------------------------------------- 

SQLSetup0001_SAM-PC_SQL.log (the last few lines)

MSI (s) (9C:EC) [13:47:02:063]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI5638.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Aug 02 13:47:02 2013
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Fri Aug 02 13:47:02 2013
MSI (s) (9C:F4) [14:00:19:984]: Running as a service.
Service control operation timeout (1053)
        Error Code: 0x8007041d (1053)
Windows Error Text: The service did not respond to the start or control request in a timely fashion.
  Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
     Function Name: sqls::Service::WaitForServiceState
Source Line Number: 951



---- Context -----------------------------------------------


Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQLSERVER



Error Code: 1053
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  (1053) The service did not respond to the start or control request in a timely fashion.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Fri Aug 02 14:04:35 2013
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Fri Aug 02 14:04:35 2013
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Either service MSSQLSERVER is not a SQL service or SQL service started but stopped before it was able to accept client connections
Unable to determine is SQL Server recovery complete (2)
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: sqlsetuplib\sqlservice.cpp
Compiler Timestamp: Mon Jun 13 14:30:50 2005
     Function Name: sqls::SqlService::Start
Source Line Number: 95



---- Context -----------------------------------------------




August 2nd, 2013 9:01pm

Issues is resolved:

When installer could not start the server service I cancelled the installation. Let the remaining installation proceed as is. Then installed SQL Server 2005 SP4. (As Server Service was not installed before the SP4, SP4 won't be upgrading it.) Then installed SQL server service from the original installation. For some unknown reason I have to reinstall client tools too.

I am not I need to reply SP4, but anyway I am going to do so.

Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2013 10:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics