[Transfer]SQL Server 2000 installation failure solution!
workaround for SQL Server 2000 installation failure!
SQL2000, which has been installed dozens of times these days, has been unable to install
GOOGLE for a long time, and finally found a solution.
system is WIN2003
error log is as follows:
starting?
Chinese_PRC_CI_AS
-m-Q-T4022-T3659
is working with service?
driver= {sql server}; server=FLYING;UID=sa;PWD=;database=master
Microsoft [SQL Server] user 'sa' login?
driver= {sql server}; server=FLYING;UID=sa;PWD= Database=master Microsoft [SQL Server] user 'sa' logindriver= {sql server}; server=FLYING;UID=sa;PWD=;database=master
Microsoft [SQL Server] user' sa' login?
SQL Server configuration? 09:47:22 Process Exit Code: (- 1) 09:47:24 setup failed to configure the server. Refer to the server error log and
C:\ WINDOWS\ sqlstp.log for more information. 09:47:24 Action CleanUpInstall: 09:47:24
C:\ DOCUME~1\ ADMINI~1\ LOCALS~1\ Temp\ SqlSetup\ Bin\ scm.exe-Silent 1
-Action 4-Service SQLSERVERAGENT 09:47:24 Process Exit Code: (1060) the specified service is not installed.
09:47:24 C:\ DOCUME~1\ ADMINI~1\ LOCALS~1\ Temp\ SqlSetup\ Bin\ scm.exe
-Silent 1-Action 4-Service MSSQLSERVER 09:47:24 Process Exit Code: (0) 09:47:24 StatsGenerate returned: 2 09:47:24 StatsGenerate
(0x80000000StatsGenerate returned: 2 09:47:24 StatsGenerate
(0x80000000memo 0xf00000ml0x100m0x52ml0x0f00000ml0x100m0x0ml0x0ml0br> StatsGenerate-1Mag Administrator) 09:47:24 Installation Failed.
solution:
sql seerver reinstalled you must pay attention to delete the original installation directory clean! It is because I am reluctant to delete the data and backup folders under disk D for 2 days (just moving it to another directory, of course). I believe that many people just put the data on disk D, and those on disk C should also delete
. First, summarize this experience as follows:
1. Deal with the installation hang problem with the following methods:
1, enter regedit
2 in the start-& gt; run, go to the HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Control\ Session Manager location
3, select the file-& gt Export, save (for security reasons)
4, right-click PendingFileRenameOperations in the right window, select delete, and then confirm
II. Solve the multi-instance problem by deleting relevant entries in the registry:
1, delete HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ Microsoft SQLServer
2, delete HKEY_LOCAL_MACHINE\ SOFTWARE\ Microsoft\ MSSQLServer
3, delete HKEY_LOCAL_USER\ SOFTWARE\ Microsoft\ Microsoft SQLServer
By lim82
Copyright Protection: ShuDudu from the original article, reproduced Please keep the link: https://www.shududu.com/life/Transfer-SQL-Server-2000-installation-failure-solution.htm