The installation of SQL Server 2005 Express Edition SP2 is failing because of an access error. I'm running the installation as Administrator. I've also turned off User Account Control off.
What I'm seeing is that neither the installation program or I can create files in some folders. These folders have an owner of SYSTEM. If I change the owner, and then the security of that folder, then the installation can proceed...until the next access error. I suppose if I had infinite patience, I could change all the permission of all the folders and get this package installed.
What am I missing? There's has got to be an easier way.
Here's the information from the Event Viewer:
Log Name: Application
Date: 8/5/2008 9:04:11 AM
Event ID: 11304
Task Category: None
Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.
<Provider Name="MsiInstaller" />
<TimeCreated SystemTime="2008-08-05T13:04:11.000Z" />
<Security UserID="S-1-5-21-2016177057-3508906939-3321019192-1005" />
<Data>Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.</Data>
The installation has not progress very far when this error occurs. The status message reads: Extracting custom action file from stream
This is a fresh install of SQL Server 2005 Express SP2, straight from http://www.microsoft.com/express/sql/download/default.aspx , on a new Vista Laptop.
I've uninstalled the failed installations and deleted files from the Program Files/Sql Server folders and retried the installation many times.
As I wrote earlier, I've investigated the permissions and ownership of the folders created by the installation. If I change the owner from SYSTEM to an administrative user, then change the permissions to make the folders writeable, the next installation proceeds further. Eventually, I lose patience.
I've tried turning the User Account Control off, but I get the same results.
My supervisor would like me to rewrite the application using Access! Help!!!