Similar to my Windows 2008 clustering adventures, I recently went through some problems when trying to cluster SQL 2008 on Windows 2008 R2. Long story short, you have to install SP1 prior to installing SQL or simply slipstream the install.
The install blew up on: There was an error setting private property ‘RequireKerberos’ to value ‘1′ for resource ‘SQL Network Name (SERVERNAME)’. Error: Value does not fall within the expected range.
To which I searched online to find that SP1 resolves the matter. So I went to uninstall, and then got this: The SQL Server failover cluster instance name ” could not be found as a cluster resource.
Followed by this: There was an error attempting to remove the configuration of the product which prevents any other action from occuring. The current configuration of the product is being cancelled as a result.
I tried to simply install SP1 to see what happens, and I get:
A failure was detected for a previous installation, patch, or repair for instance ‘MYINSTANCE’ during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_Engine_Core_Shared,SQL_PowerShell_Engine_CNS,CommonFiles,SQL_WRITER,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
So basically at this point, I was stuck. I couldn’t install, uninstall nor repair. I ended up rebuilding the server, but after posting after at SQLServerCentral.com, I was given this link which I wish I would have tried: http://support.microsoft.com/kb/953505
Anyways, after I had the server rebuilt, I finally made myself a slipstream SP1 install, which ended up resolving the issue. I’ve also come to learn that you can simply install SP1 prior to the 2008 install and then install SP1 again after the engine install to resolve these matters. If you haven’t made yourself a slipstream install, I’d highly recommend it, and it’s incredibly easy: http://blogs.msdn.com/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx
Hope this helps.
Comments