Article ID: 246694
Article Last Modified on 11/25/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q246694
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:
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
Make sure that the person that performs both the SQL Server 7.0 install and the SQL Server 7.0 service pack 1 (SP1) install, has local ADMINISTRATOR authority on the computer to which SQL is to be installed. To give ADMINISTRATOR authority on the computer, add a person's domain account to the Terminal Server computer's Local Administrators Group.
OPTION 1
To install SQL Server 7.0 and the SQL Server 7.0 service packs onto a server running Terminal Server Services, from the server's console use the Control Panel icon and double-click Add/Remove Programs.
OPTION 2
On both computers, install NetMeeting version 3.01 if it is not already present (it comes with the full install of Internet Explorer 5.0).
To obtain Microsoft's NetMeeting; from Internet Explorer 5.0, click Tools, and then select Windows Update. Select NetMeeting 3.01 to download and install NetMeeting. You may also use this Web site to download and install NetMeeting:
After NetMeeting is installed, you need to configure NetMeeting on the target computer so that Remote Desktop Sharing can be activated.
From NetMeeting, go to Tools and select Remote Desktop Sharing.... proceed through the Remote Desktop Sharing wizard, and select the Enable Remote Desktop Sharing on this computer check box. After the wizard finishes, an icon for NetMeeting Remote Desktop Sharing is placed on Taskbar.
Close NetMeeting.
Now, an icon named NetMeeting Remote Desktop Sharing is on the Taskbar. Right-click the NetMeeting Remote Desktop Sharing icon and if the Active Remote Desktop Sharing is dark black, click that phrase. This computer is now ready to be controlled from another NetMeeting session.
On the computer where the SQL Server 7.0 CD is located, make sure that the CD is shared.
Start NetMeeting. In the NetMeeting dialog box, click Call, and then click New Call. A dialog box named Place A Call opens. In the To: text box, type in either the computer name or IP address of the computer running Terminal Server. Also, make sure that you select the Require security for this call (data only) check box, and then click Call.
After you are connected to the computer with Terminal Server running, go to Control Panel, and double-click Add/Remove Programs. Install SQL Server 7.0 and SQL Server service pack 1 in this manner. When prompted for the CD, enter the UNC name of the computer holding the SQL CD (that is,: \\computername). After there is access to the CD, go to the file X86\Setup\Setupsql.exe and then proceed with the install as normal.
NOTE: Another option is to install SQL Server 2000, which will allow us to install by way of a Windows 2000 Terminal Server connection.
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, sp1, sp2, sp3, service pack
Keywords: kbbug kbnofix kbprb KB246694
