SQL

SQL Server Setup Failure Error Code 0x84B10001

Picture a scenario. You have a SQL Server failover cluster, with one or more nodes in the cluster, and the databases for your instances are presented via remote storage such as Fibre Channel or iSCSI.

When trying to install SQL 2008 R2 updates, including Cumulative Updates and Service Packs using the application .exe files downloaded from Microsoft (SQLServer2008R2SP1-KB528583-x64-ENU.exe  for example), the first thing that happens after launch is that the executable extracts the files required to drive, by default, with the largest percentage of free disk space.

Once the files have been extracted, the install wizard will start. After clicking Next, Next, Update through the wizard, the first thing the installer does is to take the SQL Server and the whole cluster resource group offline to allow it to be serviced. If the disk on which your SQL databases exist happens to be the drive with the most free space, the drive where the files where just extracted to, this drive will actually now be offline and will cause the installation to fail with the following error:

Cannot execute a program. The command being executed was “C:WINDOWSMicrosoft.NETFramework64v2.0.50727csc.exe” /noconfig /fullpaths @ “C:UsersUsernameAppDataLocalTemp6xb11xcu.cmdline”.

Error Code 0x84B10001.

The resolution to this problem is to bring the clustered disk resource online using the Failover Cluster Manager, and copy of the GUID folder which was generated by the extraction process to a local disk, or a remote storage disk which you are not servicing with the installer. I found that you need to copy the files to the local disk path before you click OK on the error message as once the update wizard terminates, it removes the temporary files.

Error 0x84B10001 can actually be initiated by other problems, however the knowledge base article at Microsoft Support advises that these other issues are resolved in a Pre-SP1 update for SQL Server 2008 R2.

Supported SQL Server Versions for System Center 2012

Following on from my post SQL Disk Space Error Installing SCAC 2012 I contacted Microsoft Premier Support to confirm the supported service pack levels for SQL Server 2008 because the release notes were very wooly as to whether Service Pack 3 was supported as well as the stated Service Pack 2.

Here is the response I recieved from them:

When I sent my request to the product group, the Group Program manager for SC 2012, replied back that those products listed are the only ones that were tested and thus fully supported.

It is entirely possible that you could run with SQL 2008 SP3 with no issues, but if a problem is encountered related to the databases we may request you relocate the database to one of the listed SQL platforms.

Until SQL Server 2008 with Service Pack 3 is recognised as tested and supported, I’d recommend that you just go with Service Pack 2 and install the latest Cumulative Update, which is currently Cumulative Update 9.

Lonely

So it’s Thursday evening, and by this time me and Nicky would have both finished our respective days working from home, and looking after Maddy for the day, except this day, there’s no Nicky. She’s out on a work do which they call an off-site. I call it a glorified team-building / skyve day but hey, but see this is where is gets worse – She’s gone tomorrow too. Thankfully she’ll be back tomorrow night, and hopefully before Maddy goes to bed otherwise she’s not going to get to see her little girl until Saturday morning.

Maddy’s been really good today, and hasn’t done anything that naughty which has made today easy for me, and has meant that I’ve been able to get quite a lot of studying done towards by next Microsoft exam, which hopefully won’t be too long around the corner, although this exam is probably one of the toughest to that I’m going to be doing as part of the Microsoft qualification so I need to make sure I’ve got it all covered properly.

Me and my boss (day to day) Colin went through my training plan a couple of days ago, and I’m going to be with Xerox now until at a minimum of 2012 due to all the training I am doing, so I could be up for a long service award before I know it :). For those of you who are interested, I’ll be finishing my Microsoft studies next year which will make me a MCSE 2003: Security and an MCTS: SQL Server 2005. Once all that is finished, I’m enrolling on a degree course through the Open University. Once that’s finished, I will have a BSc Honours degree, so I will become one of those geek people with far too many qualifications.

Read more…