SQL 2005 Express install fails as part of MS Small Business Accounting 2008

[homesleym]

Hello Everyone,


Attempting install of trial Microsoft Small Business Accounting 2009, WIN XP Pro SP2. I am logged in as administrator. The install fails with an error when trying to install the SQL program.

Copy of log:


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build
2600)
Time : Sat Jul 04 12:21:55 2009


Machine : MHLAPTOP
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLSupport_1.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLNCLI_1.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SqlWriter_1.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : MSXML 6 Service Pack 2 (KB954459)
Product Version : 6.20.1099.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_MSXML6_1.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLSupport_2.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLNCLI_2.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : MSXML 6 Service Pack 2 (KB954459)
Product Version : 6.20.1099.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_MSXML6_2.log
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : SQL Server Database Services
Error : Error writing to file: Access is denied.
. Verify that you have access to that directory.
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : SQL Server Database Services
Error : Error writing to file: Access is denied.
. Verify that you have access to that directory.
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQL.log
Last Action : StreamSupportFiles
Error String : Error writing to file: Access is denied.
Error Number : 1304
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Workstation Components, Books Online and Development Tools
Error : Error writing to file: Access is denied.
. Verify that you have access to that directory.
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Workstation Components, Books Online and Development Tools
Error : Error writing to file: Access is denied.
. Verify that you have access to that directory.
---------------------------------------------------------------------------*-----
Machine : MHLAPTOP
Product : Microsoft SQL Server 2005 Tools Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Tools.log
Last Action : StreamSupportFiles
Error String : Error writing to file: Access is denied.
Error Number : 1304
---------------------------------------------------------------------------*-----


SQL Server Setup failed. For more information, review the Setup log file in
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


Time : Sat Jul 04 12:23:38 2009


List of log files:
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Core(Local).log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLSupport_1.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLNCLI_1.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SqlWriter_1.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_MSXML6_1.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLSupport_2.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQLNCLI_2.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_MSXML6_2.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQL.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Tools.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Datastore.xml
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_.NET Framework 2.0.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SNAC.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Core.log
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_Support.log
C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SCC.log
______________________________________________________________


From:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_MHLAPTOP_SQL.log


Action start 12:23:35: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
Property(SQL): Setup Bootstrap Directory = c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\
1: 0 2: Iterating through _sqlSupportFiles entries
0:Watson 1:1304 2:StreamSupportFiles 3:streamBinaryToDisk 4:5 5:e:\sql9_sp2_t\sql\setup\darwin\sqlcastub\streamca.cpp 6:238 7:sqlcastub.dll 8:sqlrun.msi
Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: e:\sql9_sp2_t\sql\setup\darwin\sqlcastub\streamca.cpp
Compiler Timestamp: Wed Jun 14 16:27:14 2006
Function Name: streamBinaryToDisk
Source Line Number: 238
MSI (s) (94!30) [12:23:35:880]: Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.

Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.
Action ended 12:23:35: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 12:23:35: INSTALL. Return value 3.


******************************************************
I did create another user with admin rights but still the same problem. I tried to download just the SQL 2005 Express program itself from sqlexpr.exe and still got the same access denied message Error Code: 0x80070005 (5). The system config check passed with all in the green. I thought I may be missing something simple. Looking for Zebra’s and not horses.

Does the location and way the .exe file extracts have anything to do with the access denied issue?

Any help would be appreciated.

*****************************************************

System Configuration Check



- WMI Service Requirement (Success)

Messages

·WMI Service Requirement


·Check Passed



- MSXML Requirement (Success)

Messages

·MSXML Requirement


·Check Passed


- Operating System Minimum Level Requirement (Success)

Messages

·Operating System Minimum Level Requirement


·Check Passed



- Operating System Service Pack Level Requirement. (Success)

Messages

·Operating System Service Pack Level Requirement.


·Check Passed


- SQL Server Edition Operating System Compatibility (Success)

Messages

·SQL Server Edition Operating System Compatibility


·Check Passed


- Minimum Hardware Requirement (Success)

Messages

·Minimum Hardware Requirement


·Check Passed



- Pending Reboot Requirement (Success)

Messages

·Pending Reboot Requirement


·Check Passed


- Default Installation Path Permission Requirement (Success)

Messages

·Default Installation Path Permission Requirement


·Check Passed


- Internet Explorer Requirement (Success)

Messages

·Internet Explorer Requirement


·Check Passed


- COM Plus Catalog Requirement (Success)

Messages

·COM Plus Catalog Requirement


·Check Passed


- ASP.Net Version Registration Requirement (Success)

Messages

·ASP.Net Version Registration Requirement


·Check Passed


- Minimum MDAC Version Requirement (Success)

Messages

·Minimum MDAC Version Requirement



·Check Passed