“RequireKerberos” Error During the SQL 2008 Installation on Windows 2008 Cluster


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:

SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1

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:

C:\SP1\x64\setup\1033\sqlsupport.msi

5. Run the Setup.exe file from the SQL Server 2008 source media by specifying the /PCUSource parameter. For example:

Setup.exe /PCUSource=C:\SP1

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

Setup.exe

Advertisements

6 Responses to “RequireKerberos” Error During the SQL 2008 Installation on Windows 2008 Cluster

  1. Great post. Extremely Helpful

  2. database development…

    […]“RequireKerberos” Error During the SQL 2008 Installation on Windows 2008 Cluster « Notes of Windows Admin[…]…

  3. Anonymous says:

    this is great; i had same errors and the solution worked like a charm. many thanks to the publisher

  4. CT says:

    Awesome!!! Thanks for the simple to follow article that fixed a big problem. Thanks a bunch for posting and helping the community out.

  5. Jeyanthi Iyengar says:

    Thanks a million for this article. I spent 5 sleepless night configuring SQL Server Cluster until I bumped into your article.Please continue your work,

  6. Myrna says:

    Do you mind if I quote a couple of your ardticles as long as
    I provide credit and sources back to your blog?
    My blogg is in tthe very same niche as yours
    and my visitors would certainly benefit from a lot of thee information you present here.
    Please let me know if this okay with you. Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: