FIX: SQL 7.0 Setup Does Not Install Licensing on Terminal Server (278536)

SYMPTOMS

If SQL Server 7.0 is installed on a Microsoft Windows 2000 Server that has Terminal Services already installed, or on a Microsoft NT 4.0 Terminal Server, the licensing for SQL Server 7.0 may not be installed.

During an interactive/GUI setup of SQL Server 7.0, you may note that you are not prompted for Licensing information. After setup is completed successfully, select Licensing on the Control Panel, and note that there is no licensing information for SQL Server 7.0.

When you perform an unattended install, even though you specify the license mode you want in the .iss file, the Licensing manager in the Control Panel may show no information for SQL Server licensing even after setup is completed successfully.

You can also check the sqlstp.log file that is located in the \%WINDOWS% directory. When the setup routine has reached the licensing portion, it does not return the License Mode and License Limit and has output the following to the sqlstp.log:

11:26:24 Begin Action:  DlgCPLLicense
11:26:24 End Action DlgCPLLicense
11:26:24 End Action ShowDialogs

WORKAROUND

Apply any of the Service Packs for SQL Server 7.0. This problem was specifically corrected in Service Pack 1. However, because Service Packs are cumulative, all of the later Service Packs contain this fix.

If you are performing an interactive/GUI install of the Service Pack, note that you are prompted for the Licensing information. Once the Service Pack has installed successfully, you can verify that the licensing information has been set correctly in the Control Panel under Licensing.

If you are performing an unattended Service Pack install, specify the License Mode that you want in the command line call for the unattended install. For example:

To set the License Mode as Per Seat, run setup with the following parameters:

start /wait x86\setup\setupsql.exe LicMode=PERSEAT sapwd= -s -m -z -SMS -f1 "%windir%\setup.iss"

To set the License Mode as Per Server with 15 concurrent connections, run setup with the following parameters:

start /wait x86\setup\setupsql.exe LicMode=PERSERVER LicLimit=15 sapwd= -s -m -z -SMS -f1 "%windir%\setup.iss"

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

MORE INFORMATION

On NT 4.0 Terminal Server, the Release to Manufacture (RTM) version of SQL Server 7.0 is not supported. The RTM version is supported on NT 4.0 Terminal Server.eginning with SQL Server 7.0 Service Pack 1.

For more information, see Question 31 in the following Microsoft Knowledge Base article:

195759 INF: Frequently Asked Questions - SQL Server 7.0 - SQL Setup

On Windows 2000 Server with Terminal Services installed, even though RTM of SQL Server 7.0 is supported, installation of one of the SQL Server 7.0 Service Packs is required to install the licensing for SQL 7.0.