PRB: Setup on Windows 2000 Fails Through Terminal Client

ID: Q246694

The information in this article applies to:

Microsoft SQL Server version 7.0

SYMPTOMS

Installation of SQL Server 7.0 or any of the SQL 7.0 service packs from a remote Terminal Services Client onto a Windows 2000 server that is running Terminal Server Service, fails regardless of the client's operating system (Windows 95, Windows 98, Windows NT 4.0 Workstation, Windows NT 4.0 Server, or Windows 2000).

When performing a SQL Server installation, setup fails with the following error message:

Setup failed to configure the server. Refer to the server error
logs and cnfgsvr.out for more information.

The CNFGSVR.OUT file looks similar to this:


Starting Service ...
Connecting to Server ...
driver={sql server};server=.;UID=sa;PWD=;database=master
Remapping Server Databases ...
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'model'.
[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 'model'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'msdb'.
[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 'msdb'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'pubs'.
[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 'pubs'.
[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.

The last portion of the SQLSTP.LOG file will look similar to this:


13:36:33 HTML Help installer exit code: 0
13:36:33 End Action InstallPkgs
13:36:33 Begin Action BuildServer:
13:36:33 C:\WINNT\TEMP\_ISTMP7.DIR\scm.exe  -Silent 1 -Action 5 -ExePath "d:\MSSQL7\binn\sqlservr.exe"
13:36:34 Process Exit Code: (0)
13:36:35 Path successfully updated.
13:36:35 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;d:\MSSQL7\BINN
13:36:35 d:\MSSQL7\binn\cnfgsvr.exe  -Silent 2 -NoSampleDB 0 -SQLPath "d:\MSSQL7\" -SQLDataPath "d:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 196930 -User sa -Pwd
13:39:53 Process Exit Code: (1460) This operation returned because the timeout period expired.
13:42:39 Setup failed to configure the server.   Refer to the server error logs and cnfgsvr.out for more information.
13:42:39 Action CleanUpInstall:
13:42:39 C:\WINNT\TEMP\_ISTMP7.DIR\scm.exe  -Silent 1 -Action 4 -Service SQLServerAgent
13:42:39 Process Exit Code: (1060) The specified service does not exist as an installed service.
13:42:39 C:\WINNT\TEMP\_ISTMP7.DIR\scm.exe  -Silent 1 -Action 4 -Service MSSQLServer
13:42:44 Process Exit Code: (0)
13:42:44 Installation Failed.

When trying to apply a SQL Server 7.0 service pack from a Terminal Server Client, the attempt fails with the following behavior:

At the point where the service pack installation gets to the window titled CONNECT TO SERVER, no matter which selection is made, SQL SERVER AUTHENTICATION, or WINDOWS NT AUTHENTICATION, the next window will be:

"VALIDATING USER. PLEASE WAIT."

This window then hangs indefinitely until it is stopped with Task Manager.

CAUSE

Microsoft does not support SQL Server 7.0 installation on Terminal Server from the Client.

WORKAROUND

SQL Server 7.0 and the SQL 7.0 service packs can be successfully installed onto a server running Terminal Server Services from the server's console using the Control Panel icon Add/Remove Programs.

MORE INFORMATION

Note that at a minimum, SQL Server 7.0 must have service pack 1 installed before it is supported for Terminal Server usage.

Additional query words: Win2K , W2K, WIN2000

Keywords : SSrvInst kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbprb