During the SQL Server 2008 installation on Windows 2008 Cluster the following error occurs:
There was an error setting private property ‘RequireKerberos’ to value ‘1’ for resource ‘SQL Network Name (SQL-SERVER-NAME)’. Error: Value does not fall within the expected range.
This is a know issue (List of known issues when you install SQL Server on Windows 7 or on Windows Server 2008 R2) and Microsoft fixed it in SP1 for SQL Server 2008. Service Pack 1 can be found here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en
So, the only way to fix the issue is to embed (slipstream) SP1 into the original installation. Here Microsoft offers two ways to resolve the issue: Basic Slipstream or Merge Drop.
Basic Slipstream allows to run SQL setup using files from SP1, while Merge Drop creates an installation media with SP1 embedded
In order to use Basic Slipstream, do the following:
1. Install all the prerequisites for SQL Server 2008
- .NET Framework 2.0 SP2 for SQL Server 2008 Express Edition
- .NET Framework 3.5 SP1 for other editions
- Windows Installer 4.5
2. Download the service pack package that matches you system architecture. For example download the x64 package of SQL Server 2008 Service Pack 1 if your system is an x64-based system.
3. Extract the service pack by running the following command:
4. Run the service pack to install Setup files on the computer. You will receive a Setup Support Files dialog box if the Setup support files have not been installed. You can also run the following file to install the setup support files:
5. Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:
Important Post Scriptum
I posted this when my installation went further. But then It failed again with the following error
Rule “Update Setup Media Language Compatibility” failed.
The language of the original SQL Server 2008 media and the language of the service pack do not match. To continue, match the language of the service pack with the original SQL Server 2008 media.
Google brought nothing, so I opened a case with Microsoft. Well, the only change they made to my instruction was in Step 5:
5. Run the Setup.exe file from the SQL Server 2008 source media