Upgrade to SQL 2008 from 2005 (cluster) fails with The cluster group ‘SQL GROUP’ could not be moved from node ‘NODENAME1’ to node ‘null’ , 0x8007139F

Problem   We try to upgrade to SQL 2008 from SQL 2005 in a cluster setup and it fails on the Active node with the following error: From the Summary.txt There was an error during the SQL Server upgrade operation. Setup failed to move the failover cluster resource group and bring it online.  To continue…

0

SQL Express 2005 Setup Failure

ISSUE: You have SQL 2005 SP2 Express Edition or any of earlier version of SQL Express and you decide to apply SP3 to SQL Express edition. You download the http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en And start the setup and suddenly notice the below Error: The is quite strange as you would say I am not trying to install another…


Installation/Upgrading of SP4 on MSDE fails with ‘Error: 0x800401F0’

When we run the service pack 4 setup for SQL 2000 MSDE we noticed that when we launch the service pack setup the setup.exe is launched (shows up in the task manager) but exits immediately without warning! Setup in SQL Desktop Engine (MSDE), rolls back and exits if a failure is encountered, unless you specify…

0

Unable to install SQL Server 2008 Standard Edition on a Windows VISTA machine

The  error message we get is as below,   <Error Message> 02/04/2009 14:33:20.418 02/04/2009 14:33:20.419 Setup launched 02/04/2009 14:33:20.420 Attempting to determine media source 02/04/2009 14:33:20.421 Media source value not specified on command line argument. 02/04/2009 14:33:20.421 Setup is launched from media directly so default the value to the current folder. 02/04/2009 14:33:20.422 Media source:…

3

INFORMATIONAL: Understanding and Troubleshooting MSP Error: 29512 SQL Server Setup was unable add user <DomainUsername>, when you try to install SQL Server 2005

Good morning Folks! Today I will take you through a setup issue that many of you might have run into when trying to install SQL Server 2005 (especially on a cluster). I’ve tried to list down all possible solutions to the following errors one faces while installing/patching SQL Server 2005.   Hope you find this…

3

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

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

SQL Server 2005 SP2 setup might fail with the error Error 29528: The setup has encountered an unexpected error while Updating security settings on HTTP services

Few days back I worked on a case where the sql server SP2 setup was failing to install with an Error 29528 so I thought I should blog this article to address the cause of the failure and how can we resolve the issue. Problem Description: You may see the following error in the SQL…