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 :

https://docs.microsoft.com/zh-cn/archive/blogs/sqlserverfaq/info-sql-2000-msde-installation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-2

sql2000 The vitality is so tenacious ,http://www.itmop.com/downinfo/178359.html

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]  

"SQLArg3"="-T3601"

"SQLArg4"="-T3603"

copyright notice
author[shawyang],Please bring the original link to reprint, thank you.
https://en.chowdera.com/2022/175/20210526171257699p.html

Random recommended