Installation of Service Pack 3 for Reporting Services 2005 fails on a cluster with an error code 2228

The setup of the Microsoft products is considered to be extremely easy. Mostly one need to click on few “Next” buttons and the setup is done. But when the setup fails, it can be extremely interesting. I encountered one such interesting setup failure. The installation of the SQL Server service pack 3 was failing for…

1

Installing Hotfix on SQL Server may throw error 29538 and fail

In this case we were installing hotfix http://support.microsoft.com/?kbid=960089 Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3077   The Hotfix Setup would rollback. You will see the below error in the Hotfix.log file   06/24/2009 16:15:38.994 MSP Error: 29538  SQL Server Setup did not have the administrator permissions required to rename a file: d:\Program…

0

Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error

Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files.   ******************************************************** TITLE: SQL Server Setup failure. —————————— SQL Server Setup has encountered the following error: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = ‘{0826F9E4-787E-481D-83E0-BC6A57B056D5}’. Error code: 1605..   ——————————-…

38

The installation of client tools in sql 2005 fails with error 1722

Recently we encountered an issue while installation of client tools in sql 2005, so I would like to share the same in the following blog Problem Description The installation of the Client tools in SQL Server 2005 fails with the following error messages: <<Summary.txt>> Machine : <MachineName> Product : Workstation Components, Books Online and Development…


SQL Server 2005 SP2 installation hangs on a 2 Node cluster with the message: "Awaiting first complete passive cluster node"

Environment: SQL Server Enterprise Edition 2005 32 bit on Windows Server 2003 Enterprise SP1 Consider a scenario where you are installing SQL Server 2005 Servce Pack 2 on a clustered environment. Sometimes you will notice that the installation get hung while installing the patch on the passive node, the setup screen will show you following…

1

Part – 1 : SQL Server 2005 Patch Fails to install with an error "Unable to install Windows Installer MSP file"

We have seen several issues where installation of Service Pack/Hotfix/GDR/CU fails to install on one or more components of SQL Server 2005. In this blog , I have tried to include few troubleshooting tips and tricks for these kinds of installation failures.   Whenever a hotfix installation fails, we start troubleshooting  with the log file…

26

SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks

We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected failure. MSGID 50000 In order to troubleshoot the issue we followed the following steps 1)       We checked the…

1

Did you know… Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete

We have observed a number of cases where the installation of SP2 succeeds on Active Node while it may fail on the passive node while installing SP2 on the clustered instance of SQL server 2005. In order to find the cause of the failure on passive node we need to check Summary.txt log in the…

1

Facts about How SQL Server 2008 setup works… #3

Setup.exe can be patched dynamically on the fly One of the drawbacks of the sql server 2005 setup was that if there was any bug detected in the code of the setup.exe , the patching of the setup.exe was difficult and at times next to impossible. With Katmai, it is possible to patch the setup.exe…

2

Facts about How SQL Server 2008 setup works… #2

Salient Features of Sql Server 2008 (Katmai) SetupMinimize the MSI code for setup and use MSI code for what it does the best.In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause of many setup failures in sql 2005. However in…

1