Unable to install MSI packages in SBS 2003 SP2

Posted on 2009-02-08
Last Modified: 2012-05-06
So I decided to make the plunge from SQL Server 2000 to 2008.  Fun fun.

I attempted to download the SQL Server Upgrade Advisor:

And attempted to launch the .msi file, and received an error:

The installation package cannot be installed by the Windows Installer service.  You must install a Windows service pack that contains a newer version of the Windows Installer service.

I'm running Windows SBS 2003 w/ Service Pack 2 installed.  I dont see any updates out there regarding this issue.  Does anyone have any ideas?
Question by:mtuepker
    LVL 27

    Accepted Solution

    did you try to upgrade windows installer ?
    Windows Installer 4.5 Redistributable is the latest I think
    LVL 1

    Author Closing Comment

    Thanks, simple as that.  I google searched windows installer, and for some reason all i could find was for 3.1.  thanks!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now