You are currently offline, waiting for your internet to reconnect

Error message when you install a 32-bit version of SQL Server 2005 on a server that is running an X64 version of SQL Server 2005 with SP2: "Windows Installer has stopped working"

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SYMPTOMS
When you install a 32-bit version of Microsoft SQL Server 2005 on a server that is running an X64 version of SQL Server 2005 with Service Pack 2 (SP2), you receive the following error message during the installation of the SQL Server 2005 Database Engine:
Windows Installer has stopped working
CAUSE
This problem occurs because a file that is shared between the 32-bit version of SQL Server 2005 and the X64 version of SQL Server 2005 is not updated correctly.
WORKAROUND
To work around this problem, install the Setup Support Files component from the 32-bit version of SQL Server 2005 SP2. To do this, follow these steps:
  1. Download the 32-bit version of SQL Server 2005 SP2.
  2. Double-click the SQL Server 2005 SP2 package.
  3. On the Feature Selection page, select the Setup Support Files check box.
  4. Clear other check boxes if they are selected.
  5. Follow the rest of the installation steps.
After you install the Setup Support Files component, you can install the 32-bit version of SQL Server 2005.
REFERENCES
For more information about how to obtain SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
913089 How to obtain the latest service pack for SQL Server 2005
Properties

Article ID: 945935 - Last Review: 02/05/2008 02:07:11 - Revision: 2.1

Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Workgroup Edition

  • kbtshoot kbexpertiseadvanced kbprb KB945935
Feedback
body>.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> &t=">body>