SQL Server 2008 R2 – Version’s parameters must be greater than or equal to zero

A third (!) and hopefully final blog post on SQL Server 2008 R2 deployment woes. Previous posts include SQL Server 2008 R2 – Version string portion was too short or too long and SQL Server 2008 R2 – Error code: 1605.

This time the installation problem comes with the following beauty:

Exception type: System.ArgumentOutOfRangeException
Message: Version's parameters must be greater than or equal to zero.
Parameter name: build

In this particular case, it appears the SQL Server 2008 R2 installer detects some SQL Server 2000 residues on the client and fails to determine its version.

SQL Server 2000

A quick investigation of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server reveals that the 80\Tools key is still present on the machine, even though SQL Server 2000 has been uninstalled. Not surprisingly, the ClientSetup key, which denotes the version, is missing.

Two options:

  1. Install SQL Server 2000 before 2008 R2 – which is not an elegant solution.
  2. Give the SQL Server 2008 R2 installer a helping hand by recreating the missing key and value pairs

Solution

Dump the following info into a fix.reg file or recreate the following in the registry manually and the SQL Server 2008 R2 installer should continue successfully:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup\CurrentVersion]
"Language"=dword:00000409
"CurrentVersion"="8.00.194"
"CSDVersionNumber"=dword:00000300
"CSDVersion"="8.00.760"

Advertisements

7 Responses to SQL Server 2008 R2 – Version’s parameters must be greater than or equal to zero

  1. Pingback: SQL Server 2008 R2 – The performance counter registry hive is corrupted. « IT. Tech. Internet.

  2. Ankur Dawada says:

    It Shows the same error…

    TITLE: SQL Server Setup failure.
    ——————————

    SQL Server Setup has encountered the following error:

    Version’s parameters must be greater than or equal to zero.
    Parameter name: build.

    ——————————
    BUTTONS:

    OK
    ——————————

  3. Shannon Sellers says:

    Worked perfectly Thanks!

  4. chris says:

    was hoping for a fix – but no dice. thanks for posting!

  5. Rose Aylward says:

    Try this for the guys where it didn’t work…there is another link at the bottom of the article I’m linking which may also help:

    http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/31/sql-server-2008-r2-setup-fails-on-windows-7-with-the-error-version-s-parameters-must-be-greater-than-or-equal-to-zero.aspx

  6. Jeremy says:

    Thanks!

  7. Steve says:

    Thank you, this fix worked for me!

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: