Tuesday, March 27, 2012

Error installing SQL Express 2005 SP1 on XP Home/SP2

As the subject says, I am getting an error installing SQL Express 2005 SP1 on XP Home/SP2. I have never had a previous version of SQL server installed. I have never had Visual Studio installed. I have tried extracting the setup files and running from a different directory. I have tried installing the advanced package as well with the same results.

When I run the setup, the Client and support files are successfully installed. It then goes on to the system analysis, where I get one warning about my hardware but I have checked the help file and my system appears to meet the system requirements. After I click Next from this window is where I get the error,
"Error writing to file: Access is denied.
. Verify that you have access to that directory."

After looking into the log files I see this,

Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp
Compiler Timestamp: Wed Dec 21 16:49:23 2005
Function Name: streamBinaryToDisk
Source Line Number: 238
Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.

Does anyone know what is wrong? I have installed this on many W2K machines at work as well as installed the full version of SQL Server 2005. I have never seen these errors on any of those machines. This is the first XP machine I have ever tried to install on so I am not sure if this is an OS problem or not.

Thanks in advance.

I have the same problem (win xp pro sp2), please help us....

thank you

|||

Are you familar with using regedit? If so, can you post the contents of the "BootstrapDir" and "WYukonBootstrapDir" values (if they exist), in the "HKLM\Software\Microsoft\Microsoft SQL Server\90" key?

|||

R. Green - MSFT wrote:

Are you familar with using regedit? If so, can you post the contents of the "BootstrapDir" and "WYukonBootstrapDir" values (if they exist), in the "HKLM\Software\Microsoft\Microsoft SQL Server\90" key?

I will check that as soon as I get home, thanks.|||Here is what I have for the BootstrapDir, C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\|||

That is the correct value. The custom action should be running with the credentials of the user running setup, which in this case would be your logged in account. Setup is trying to create a file in a "Bin" subfolder of that directory. Could you use Windows Explorer to navigate to that folder and see if you are able to create that directory? Also check to see if it the folder already exists and if it has any files. If so, try to delete the entire folder. Let me know what you find out, thanks!

|||

Could you also post the line(s) in the log immediately prior to what you posted earlier. There should be line(s) like this:

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:32 5:t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp 6:238 7:sqlcastub.dll 8:sqlrun.msi

I would like to confirm that it is actually reading the correct value from the registry. Thanks!

|||Unfortunately I will have to wait to get home again, as that is where the PC with the problem is. I will reply as soon as I can with the requested info.

Thanks for your time as it is much appreciated,
Scott|||

R. Green - MSFT wrote:

Could you also post the line(s) in the log immediately prior to what you posted earlier. There should be line(s) like this:

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:32 5:t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp 6:238 7:sqlcastub.dll 8:sqlrun.msi

I would like to confirm that it is actually reading the correct value from the registry. Thanks!

Here is the whole chunk again but with the extra you asked for and more, but I don't see exactly what you were looking for though:

MSI (c) (CC:B4) [23:45:05:931]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 23:45:05: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream
Action start 23:45:05: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (CC:70) [23:45:05:941]: Invoking remote custom action. DLL: C:\DOCUME~1\Owner\LOCALS~1\Temp\MSIB9.tmp, Entrypoint: StreamSupportFiles
MSI (c) (CC:3C) [23:45:05:941]: Cloaking enabled.
MSI (c) (CC:3C) [23:45:05:941]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (CC:3C) [23:45:05:941]: Connected to service for CA interface.
Property(SQL): Setup Bootstrap Directory = C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\
1: 0 2: Iterating through _sqlSupportFiles entries
Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp
Compiler Timestamp: Wed Dec 21 16:49:23 2005
Function Name: streamBinaryToDisk
Source Line Number: 238
Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.
MSI (c) (CC!B8) [23:45:07:684]: Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.

Action ended 23:45:07: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (c) (CC:B4) [23:45:07:684]: Skipping action: FatalError (condition is false)
Action ended 23:45:07: INSTALL. Return value 3.
MSI (c) (CC:B4) [23:45:07:684]: Destroying RemoteAPI object.
MSI (c) (CC:3C) [23:45:07:694]: Custom Action Manager thread ending|||I also noticed this in the CORE log file:

Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.2047.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2006/10/2 23:45:8, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Running: ReportChainingResults at: 2006/10/2 23:45:8
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Mon Jan 16 02:06:13 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3140

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_NOTEBOOK_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/10/2 23:45:9
Message pump returning: 1603
|||

Thanks for the follow-up. Did you notice if any files were there already in the directory? Were you able to create the "Bin" folder if it didn't exist? Can you also try to create a file in the "Bin" subfolder?

The logs look like it is trying to create the right file in the right spot, so if you are able to create files by hand there is a mystery going on here.

|||

R. Green - MSFT wrote:

Thanks for the follow-up. Did you notice if any files were there already in the directory? Were you able to create the "Bin" folder if it didn't exist? Can you also try to create a file in the "Bin" subfolder?

The logs look like it is trying to create the right file in the right spot, so if you are able to create files by hand there is a mystery going on here.

Sorry it took so long getting back to you. Actually as it turns out, I cannot create a file in the Bin directory. I am logged in as a user with Administrative rights but not as Administrator. Could that be the problem?|||

That would be the cause of the problem, although I'm not sure how the permissions got screwed up. You shouldn't need to run as the Administrator account, running with an account that is a member of the Administrators group is good enough.

You could try logging in as Administrator and deleting the folder, which would delete the bogus ACL's on it. Then log back in again with your regular account and try setup once more. I assume this will work since setup doesn't have problems creating files in the other folders under "Setup Bootstrap", it seems localized to just the "Bin" folder.

|||Ok, I finally got it installed. It is important to note that I am running Windows XP Home. You cannot login as Administrator in Home unless in safe mode. Here is what I did,

1) Run the setup for SQL Server Express 2005. When it fails, restart the computer in Safe Mode.
2) Login to Safe Mode as the Administrator.
3) In File Explorer right click on the c:\Program Files\Microsoft SQL Server directory. Change the permissions to full control for all administrators.
4) Restart into normal mode and login as the same user you originally started the installation with.
5) Re-run the installation, without uninstalling the failed installation.
6) It should install without a problem now.

I am going to assume that this is a problem with XP Home not allowing the use of the Administrator account in normal mode. If anyone ever figures out exactly what the problem is I would love to know.

Good luck to all, and thanks for all the help.

Scott

No comments:

Post a Comment