Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mudgey
Starting Member
1 Post |
 Posted - 2007-07-16 : 23:13:08
|
| Hi,I am currently attempting to re-install SQLServer2000 on a Win2K server -SP4. I have uninstalled this previously (via add/remove programs and also removing all reg keys for the default instance - as outlined in a couple of topics). I am receiving an error during the "Configure Server" step which is returning the error 'Setup failed to configure the server'.The error listed in the sqlstp.log is: 12:02:28 Process Exit Code: (128) There are no child processes to wait for. this is a local install using a local admin account.I see there maybe some issues with installing SQL2000 after SP4...any suggestions Thanks AdrianSQLSTP.log entry:12:02:25 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 65970 -U sa -P 12:02:28 Process Exit Code: (128) There are no child processes to wait for.12:04:06 Setup failed to configure the server. Refer to the server error logs and C:\WINNT\sqlstp.log for more information.12:04:07 Action CleanUpInstall:12:04:07 C:\DOCUME~1\qtcadmin\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT12:04:07 Process Exit Code: (1060) The specified service does not exist as an installed service.12:04:07 C:\DOCUME~1\qtcadmin\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER12:04:07 Process Exit Code: (0) 12:04:07 StatsGenerate returned: 212:04:07 StatsGenerate (0x0,0x1,0xf0000000,0x400,1033,303,0x0,0x1,0,0,012:04:07 StatsGenerate -1,qtcadmin)12:04:07 Installation Failed. |
|
|
alexsqlforum
Starting Member
3 Posts |
Posted - 2007-07-23 : 16:58:17
|
| 1. Reboot2. Remove all known instances of SQL ServerTo remove all known instances of SQL Server, follow these steps: A. Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder. B. Locate, and then delete these registry keys: • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server C. Locate, and then delete these registry keys: • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper D. The three registry keys in step D correspond to the default instance of Microsoft SQL Server 2000. Named instances appear similar to those listed in step D, along with $instance_name, because instance_name is the name given to your particular instance. After you locate the correct keys for the instance you are removing, select those keys, and then delete them. • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer$InstanceName • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper E. If the instance of SQL Server you are removing was clustered, remove any cluster resources for the instance that may remain in the Cluster Administrator. Note Only remove SQL Server resources. F. Reinstall Microsoft SQL Server 2000 and use the same name, and IP address. G. Run the Setup for the installation, and use the Uninstall option to clean up any configuration problems or errors that may still exist because of the failed installation. Note If this is a clustered instance of SQL Server 2000, repeat these steps for each node in the cluster. Back to the top3.Delete contents of Temp folders before you reinstall SQL ServerDelete all contents from the Temp folder of both the System Temp and the Temp folder of the installing user. To determine the location of the Temp folder for the user, type the following command at a command prompt:C:\Documents and Settings\username>set tThe results should include the following:TEMP=C:\DOCUME~1\username\LOCALS~1\TempTMP=C:\DOCUME~1\username\LOCALS~1\Temp4. Stop all non-essential services (vendor specific utilies, anti virus programs, Exchange,IIS...etc) 5. Run setup again |
 |
|
|
|
|
|
|
|
Process Exit Code (128) when Installing