Microsoft SQL Server 2005 Express Setup - Installation / Incompatible Components

Hi,

I'm having trouble installing SQL Server 2005 Express.  It keeps giving this message:  "SQL Server 2005 Setup has detected incompatible components from Beta versions of Visual Studio, .NET Framework, or SQL Server 2005.  Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again.  . . ."  I installed a Beta version of Visual Studio over a year ago, and this may be causing the problem, however, I have tried uninstalling everything (Add/Remove Programs), and I still get this message.  I have also tried manually deleting in Windows Explorer the "Microsoft SQL Server" folder and its contents, which I suspect might be causing the problem,  from my C: drive.  However, I keep getting this message:  "Cannot delete instapi.dll [or similar message for some other files]:  Access is denied.  Make sure the disk is not full or write-protected and that the file is not currently in use."  I've re-booted my machine and tried deleting again, so it shouldn't be in use, and the disk is certainly not full.  However, the property attributes show "Read Only" checked, and when I try to uncheck "Read Only" and apply it, I go back in and it shows "Read Only" checked again.  They are not under any "Shared Documents" folders that I'm aware of.  So I can't delete these remaining files and folders so I can try installing again.

Is this possibly the problem   If so, how can I delete these files once and for all   If this is not the problem, what is, and what's the solution

Thanks in advance.



Answer this question

Microsoft SQL Server 2005 Express Setup - Installation / Incompatible Components

  • SteveWeaver

    The windows install cleanup worked well 4 me



  • Jphillips59

    I have this problem with instapi.dll.

    I can not install Microsoft SQL Server 2005 Express.

    I don't have installation disks, since I installed SQL previously from the web.

    I A/R [uninstalled] the previous version of SQL Server Express (and VWD Express).

    Unfortunately, I deleted the log file mentioned above.

    I did everything that I was supposed to do -- am I to be left in this state forever or do I have to reinstall everything including my XP Pro to recover...

    I've given up on Microsoft SQL Server Express and VWD Express - but does this mean that I'll never be able to install SQL Server 2005 on this PC.

    My experience with VWD Express and SQL Server 2005 Express has been horrendous - a real nightmare. I had a similar experience with a trial version of Win 2003 Server...No more trials for me, I've learned my lesson...

    I know the sofware are freebies - but this is really sad.


  • djfrey

    The better forum to post in would be SQL Server\SQL Server Setup & Upgrade

    http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=95&SiteID=1

    Try the Windows Installer clean up tool first.

     
    Otherwise, try the following:
     
    Please look at the %Program Files%\Microsoft SQL Server\90\Setup
    Bootstrap\LOG\Files\SQLSetup*_Core.log file.  It should have a bit of
    information in it saying what the conflict is and some GUIDs indicating
    the product codes of the conflicting programs.  The section you are looking
    for will look something like this (and may repeat):
     
        Running: PerformSCCAction2 at: 2004/6/27 13:54:12
        Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 
        9.00.823 is not compatible with current builds of SQL 
        Server.Expected at least version: 9.00.849
        The Product Name is "Microsoft SQL Server 2005 Analysis 
        Services Beta 2"
     
    In this case, the offending product is “Microsoft SQL Server 2005 Analysis 
    Services Beta 2" with a product code of
    "{982DB00A-9C4E-436B-8707-18E113BAA44C}"
     
    If the programs are still visible in the Add/Remove Programs control panel (ARP),
    please remove them in the order specified by the readme file.  If they are not in
    ARP, please run the following steps: 
     
    Assuming you still have the media for the old build,
    1/ Uninstall SQL Support files.
    2/ Uninstall SQL Native Client (SNAC)
    3/ Uninstall .NET Frameworks 2.0
    4/ Run the old setup.exe up until it starts asking you what you want to install
    (let it install SNAC/MDAC and .NET), then exit setup.
    5/ (**Skip this step for: SNAC, MDAC, SQL Support Files and
         .NET Frameworks 2.0)
     run "msiexec /x {ProductGUID} /l*v c:\logfile.txt" for each of the
    ProductGUIDs listed in your Core log file from above.

    Assuming that succeeds,
    6/ Uninstall SQL Support Files
    7/ Uninstall SQL Native Client
    8/ Uninstall .NET Frameworks 2.0
    9/ Install RTM.


  • saniya

     

    When you install the beta systems, there are a lotof entries put into the Registry as well as other folders on the machine. Have you tried running the uninstall tools, These tools will target the known registry, folders and programs and uninstall them cleanly.

    I would have a look at some of the posts in the following thread and see if they can help.

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=134495&SiteID=1



  • RonenP

              Exactly same thing happened to my installation, after I uninstalled SQLExpress , deleted files from HD and tried to reinstall it.

              After several attempts to install, manual cleaning registry, I started from scratch: downloaded and saved SQLExpress, used Installer Cleaning Tool, link in Jeffrey post above, deleted SQL directory on HD. Next step was to install SQLExpress from saved file with Advanced Options enabled.

               It seemed, previously SQLExpress  did not installed, due to residual same instances  from previous installations, so I changed SQLExpress instance to different name in advanced options. Whole SQL Express has been installed and  being working fine, so give it a try before whole Windows reinstallation.

               Lynchnco, just be cool, perhaps this software is freebie, but for many is great learning tool and Microsoft, by giving it for free, will get a lot of data about experience from users, to improve product. It is win-win situation, isn’t it


  • Microsoft SQL Server 2005 Express Setup - Installation / Incompatible Components