ShuDudu's Home was started in 2011, but the web data is lost, so now begin again, I would like to make some friends, I hope you like ShuDudu's home.
Current position: ShuDudu > Life >

[Transfer]SQL Server 2000 installation failure solution!

Tuesday on January 30th, 2007Life

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' login

driver= {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