none
Access denied when installing SQL Server 2005 Express Edition SP2

    Question

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

     

    Thanks,

    Barry

    Saturday, August 02, 2008 2:11 AM

Answers

  • I've rewritten the program to use Access, and the clients are moving from Vista to XP.  That's real progress.

    Monday, August 11, 2008 12:58 PM

All replies

  • Here's the information from the Event Viewer:

     

    Log Name:      Application
    Source:        MsiInstaller
    Date:          8/5/2008 9:04:11 AM
    Event ID:      11304
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          CAPC2008\CAPC
    Computer:      CAPC2008
    Description:
    Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
    .  Verify that you have access to that directory.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MsiInstaller" />
        <EventID Qualifiers="0">11304</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2008-08-05T13:04:11.000Z" />
        <EventRecordID>2694</EventRecordID>
        <Channel>Application</Channel>
        <Computer>CAPC2008</Computer>
        <Security UserID="S-1-5-21-2016177057-3508906939-3321019192-1005" />
      </System>
      <EventData>
        <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>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>
        </Data>
        <Data>
        </Data>
        <Binary>7B36433432383237372D323332442D344343322D393045442D4131444346453744463634467D</Binary>
      </EventData>
    </Event>

     

    The installation has not progress very far when this error occurs.  The status message reads:  Extracting custom action file from stream

     

     

    Tuesday, August 05, 2008 1:20 PM
  • 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!!!

     

     

    Tuesday, August 05, 2008 9:12 PM
  • I've rewritten the program to use Access, and the clients are moving from Vista to XP.  That's real progress.

    Monday, August 11, 2008 12:58 PM