SQL Server 2008 R2 setup fails on Windows 7 with the error: Version's parameters must be greater than or equal to zero

  • Artykuł

Symptom:

While installing SQL Server 2008 R2 RTM in a Windows 7 box, noticed an error message:

SQL Server Setup has encountered the following error:

Version's parameters must be greater than or equal to zero.

This error occurs after Setup Support Files are installed and then setup is trying to gather existing SQL components installation information.

From the error message, it looks more like setup is trying to read Version information about a SQL component and it either finds it as NULL or NAN (Not a number).

Cause:

SQL 2000 client-network utility was installed in the box but the registry entries that specify the version and the language for SQL Server 2000 Tools are missing or incorrect.

Work around:

Method 1 (Recommended approach):

            Re-install SQL Server 2000 client components.

Method 2:

1. Click Start, click Run, type regedit, and then click OK.

2. Locate and then click the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\

3. Create new key ClientSetup under above location

4. Create new key CurrentVersion under 80\Tools\ClientSetup\

5. On the Edit menu, point to New, and then click String Value.

6. Type CurrentVersion, and then press ENTER.

7. Double-click CurrentVersion, type 8.00.0194 in the Value data box, and then click OK.

8. On the Edit menu, point to New, and then click DWORD Value.

9. Type Language, and then press ENTER.

10. Double-click Language, type 409 in the Value data box (Make sure that hexadecimal radio button is highlighted), and then click OK.

Note: 409 here corresponds to English – United States which is the locale of SQL Server installation. Locale IDs assigned by MS can be looked up here https://msdn.microsoft.com/en-us/goglobal/bb964664.aspx. The language version of your SQL Server installation can be found by checking the properties of setupsql.exe in your SQL Server installation media

11. Exit Registry Editor.

Note:

There is also a similar issue reported at https://support.microsoft.com/kb/973301 and it is about SQL Server 2008 with different error message.

Regards,
Sakthivel Chidambaram
SE, SQL support

Rakesh Singh & Shamik Ghosh

TL, SQL support

Comments

  • Anonymous
    June 01, 2010
    Workstation with XP pro installed, no privious SQL server installed on it. Got the message: 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.

Tryed the solution on this page, didn't work, the parameters didn't exist from the beginning, when there is no SQL things installed. Read about this fenomen on several different sites with different solutions, none of them worked. After 4 hours reading and testing I desided to test another thing. I downloaded SQL server 2005 express and installed it, after that I started the SQL server 2008 r 2 installation. It went thru without any problem, so my recommendation is to install the express and then install the full version after that, it will go so smoooth.

  • Anonymous
    June 21, 2010
    The comment has been removed

  • Anonymous
    August 16, 2010
    I ran into this on Windows XP. Everything worked fine as soon as I implemented the registry fix as described.

  • Anonymous
    September 26, 2010
    The comment has been removed

  • Anonymous
    January 12, 2011
    the suggestion work fine for me, but the suggested string must be created on this path. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server80ToolsClientSetupCurrentVersion Best regards.

  • Anonymous
    June 07, 2011
    Method 2 worked to perfection for Windows XP.

  • Anonymous
    June 08, 2011
    SQL Server Setup has encountered the following error: SQL Server 2008 R2 setup100.exe and setuppatch.exe cannot be run in this mode. If you are running setup100.exe, start setup.exe instead. If you are running setuppatch.exe, run it from the command prompt, as the user interface is not supported for this action. For more information about Setup, see SQL Server Books Online. Error code 0x84B20001.

BUTTONS: OK

  • Anonymous
    February 21, 2012
    The comment has been removed

  • Anonymous
    February 21, 2012
    Workaround 2 works fine. Thanks!

  • Anonymous
    February 21, 2012
    Workaround 2 works fine. Thanks!

  • Anonymous
    April 17, 2012
    create a .reg file with the following and add it, also back up the registry just in case! Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server80ToolsClientSetupCurrentVersion] "Language"=dword:00000409 "CurrentVersion"="8.00.194" "CSDVersionNumber"=dword:00000300 "CSDVersion"="8.00.760"

  • Anonymous
    February 26, 2014
    If machine is 64 Bits Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftMicrosoft SQL Server80ToolsClientSetupCurrentVersion] "Language"=dword:00000409 "CurrentVersion"="8.00.194" "CSDVersionNumber"=dword:00000300 "CSDVersion"="8.00.760"

    • Anonymous
      March 22, 2016
      Cristian Palma, very thank.your information was really helpfull.If your Operating System is x64 (64Bits) then, edit registry with these value.Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\80\ToolsClientSetup\CurrentVersion]"Language"=dword:00000409"CurrentVersion"="8.00.194""CSDVersionNumber"=dword:00000300"CSDVersion"="8.00.760"Good Luck!

  • Anonymous
    October 01, 2014
    thanks Cristian Palma, your information was really helpfull

  • Anonymous
    December 04, 2014
    Getting same error while installing SQL 2012 Dev edition, any specific settings for SQL 2012..??

  • Anonymous
    September 03, 2015
    bienn amigooo grasias por la informacionnn mi correo: leo_lt9212@hotmail.com