current position:Home>Sqlserver 2000 has long-lasting vitality

Sqlserver 2000 has long-lasting vitality

2022-06-24 12:44:43shawyang

Microsoft's early SqlServer database (SqlServer2000、2005 Low version ) There is a problem with the installation or startup , The solution is as follows

Because of Microsoft's early SqlServer The database exists 2^n Of bug, The physical machine CPU The kernel is not 2^n You need a patch

If the core count of the master computer is 2^n No need to import the registry , Most of the cores of the master computer are not 2^n Most physical machines CPU None of them 2^n, yes 2^n There are 32 Nuclear CDH,32c CDH Assigned to cvm Use SqlServer2000、2005 The lower version does not require the import patch Microsoft bug explain :

sql2000 The vitality is so tenacious ,

You need to import the registry patch before running

As shown in the figure , Pay attention to the instance name , What is it , The registry path will be replaced

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432node\Microsoft\Microsoft SQL Server\ Instance name \MSSQLServer\Parameters]  



copyright notice
author[shawyang],Please bring the original link to reprint, thank you.

Random recommended