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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Unable to install SQL 7 on W2K Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-15 : 08:32:31
Joe writes "Box Specs:
Dual 667MHz P3 CPUs
Win2000 Server SP2
512MB RAM
Single Channel RAID 5
2 NICs
4GB System Partition
2GB Swap Partition
20GB Data Partition

MS SQL Version 7.0 Standard

I've tried several different ways to install with no luck. The MS Knowledge Base said it couldn't be done via Terminal Services. Therefore, I tried using Add/Remove Programs, as well as WINVNC with no luck. I stopped several non-essential services prior to installation as well. I am a HTML/ColdFusion guy taking on a new role. I am a SQL newbie. Any help you can offer would be greatly appreciated. I'd like to avoid the $300 phone call to MS.

Thanks,

Joe

Pasted below are the last few lines of cnfgsvr.out located in the \MSSQL7\Install\ Directory.

-----------------------

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'Northwind'.

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'Northwind'.

Disconnecting from Server ...

Stopping Service ...

Starting Service ...

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

------------------------------------

Pasted are the last several lines of sqlstp.txt located in the \WINNT\ directory.

------------------------------------------

13:37:44 End Action LogSelectedComponents
13:37:44 Begin Action MoveFileData:
13:37:54 End Action MoveFileData
13:37:54 Begin Action ProcessAfterDataMove:
13:37:54 DeinstallSetReference (C:\MSSQL7\sqlservr.exe) returned: 0
13:37:54 End Action ProcessAfterDataMove
13:37:54 Begin Action InstallPkgs:
13:37:54 Setup is installing Microsoft Management Console (MMC) ...
13:37:54 E:\x86\Other\instmmc.exe /Q
13:38:16 Process Exit Code: (0)
13:38:16 Setup is installing HTML Help ...
13:38:17 HTML Help installer exit code: 0
13:38:17 End Action InstallPkgs
13:38:17 Begin Action BuildServer:
13:38:17 C:\WINNT\TEMP\_ISTMP28.DIR\scm.exe -Silent 1 -Action 5 -ExePath "C:\MSSQL7\binn\sqlservr.exe"
13:38:17 Process Exit Code: (0)
13:38:17 Path successfully updated.
13:38:17 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\nsr\bin;F:\MSSQL7\BINN;C:\MSSQL7\BINN
13:38:17 C:\MSSQL7\binn\cnfgsvr.exe -Silent 2 -NoSampleDB 0 -SQLPath "C:\MSSQL7\" -SQLDataPath "f:\mssql7data\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 1310838 -User sa -Pwd
13:41:27 Process Exit Code: (1460) This operation returned because the timeout period expired.

13:41:44 Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.
13:41:44 Action CleanUpInstall:
13:41:44 C:\WINNT\TEMP\_ISTMP28.DIR\scm.exe -Silent 1 -Action 4 -Service SQLServerAgent
13:41:44 Process Exit Code: (1060) The specified service does not exist as an installed service.

13:41:44 C:\WINNT\TEMP\_ISTMP28.DIR\scm.exe -Silent 1 -Action 4 -Service MSSQLServer
13:41:49 Process Exit Code: (0)
13:41:49 Installation Failed."
   

- Advertisement -