BUG: SQL 7.0 Desktop Edition Install on Windows 98 Causes "Assertion Failed File: ..\SRC\SQLSSPI.C Line: 119"

This article was previously published under Q229608
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 55333 (SQLBUG_70)

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
The installation of SQL Server 7.0 covers several stages such as product registration, specifying program file locations, file copying, and various screen messages stating what components are being installed and configured. The installation process may reach the point of: "Connecting to server...", and stop responding. If you press CTRL-ALT-DELETE this message occurs:
Desktop Edition (Not responding).
If the task is stopped and the computer rebooted, the installation may appear to have finished since the SQL Server 7.0 program group may be present.

If you then attempt to connect with any of the client utilities such as SQL Enterprise Manager or Query Analyzer, the following error appears:
Microsoft Visual C++ runtime library
Assertion Failed
Program: C;\Windows\MMC.EXE
Line: 119
Expression: Count
For information on how your program can cause an assertion fault, please see the Vision C++ Documentation on Assert.
(Press retry to debug the application-JIT must be enabled
{Retry} {Abort} {Ignore}
The SQL Server error log file located in the C:\MSSQL7\LOG\ERRORLOG directory may have the following lines:
ods      Error: 17826, Severity: 18, State: 1ods      Could not set up ListenOn connection 'SERVERNAME'..ods      Operating system error 1747., The authentication service is unknown.				
The SQL Server 7.0 installation log file located in the C:\WINDOWS\SQLSTP.LOG directory may end with the following lines:
11:56:49 Desktop override enabled.11:56:50 SetNewPath returned: 301011:56:50 Path successfully updated.11:56:51 C:\MSSQL7\binn\cnfgsvr.exe  -Silent 2 -NoSampleDB 0 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 1164 -User sa -Pwd				
Typically, the SQLSTP.log file should have many more lines past the last line in the preceding example.

Additionally, the SQL Server 7.0 installation's configuration log file located in the C:\MSSQL7\INSTALL\CNFGSVR.OUT directory may end with the following lines:
Starting Service ...
Connecting to Server ...
driver={sql server};server=MACHINENAME;UID=sa;PWD=;database=master
Typically, the CNFGSVR.out file should have many more lines past the last line in the preceding example.
Running the SQL Server 7.0 setup on a Windows 98 computer that does NOT have "Client for MS Networks" as the "Primary Network Logon".
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

In Windows 98 the default setting for Network properties is "Family Logon" for the primary logon, this is especially true if there is NO NETWORK CARD INSTALLED. Consequently, "Family Logon" may interfere with the SQL Server 7.0 install.To correct the error use the following:
  1. Uninstall SQL Server 7.0, either from the Microsoft SQL Server 7.0 program icon, or by using the Add/Remove icon in Control Panel. However, if this fails then manually delete the MSSQL7 directory, and remove the following registry key(s) if they exist:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 7.0
    2. Navigate to Control Panel and double-click Networking. Click the Configuration tab and check to see if "Client for MS Networks" is present in the Network properties. If it is, set it to "Primary Network Logon", reboot the computer and then reinstall SQL Server 7.0.
    3. If "Client for MS Networks" is not present, click the ADD button, choose "Client", select Microsoft, and then highlight "Client for MS Networks". Next, click OK, then reboot the computer. If prompted for a network card and no card exists, cancel out of the window and proceed to the next paragraph in this article. To avoid any future logon problems, make sure the properties of "Client for MS Networks" are examined. Make certain that the "Log on to Windows NT Domain" check box is NOT selected. NOTE: Be sure to have the Windows 98 CD available because a prompt for it may occur.
    4. Navigate to My Computer, then check to see if "Dial up Networking" is present. If it is not present, open Control Panel and choose the Add/Remove Programs icon. Go to the Windows Setup tab, highlight the Communications check box and press the Details button. Select "Dial up Networking" and then click OK.
    5. In Control Panel, choose the Network icon. Select the Configuration tab and choose "Client for MS Networks" as the Primary Network Logon. To avoid any future logon problems, review the properties for "Client for MS Networks" and make sure that the "Log on to Windows NT Domain" check box is NOT selected. Next, reboot the computer.NOTE: Be sure to have the Windows 98 CD handy because a prompt for it may occur.
    6. Reinstall SQL Server 7.0.
    After SQL 7.0 is installed, the "Primary Network Logon" may be changed from "Clients for Microsoft Networks", to "Family Login" if necessary, but "Clients for Microsoft Networks" must remain as one of the network components.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
More information
This problem also affects SQL Server 2000 Personal Edition and the Desktop Engine on the Original Edition of Windows 98, but does not affect computers that use Windows 98 Second Edition. The symptoms of this problem on SQL Server 2000 are slightly different. The following are the log files and messages that you would see if this problem is occurring on your system.

If the installation reaches the point where the computer stops responding and displays the message:
Setup is starting and installing your chosen configuration...					
then you should check to see if Client for MS Networks is missing or is not set as the Primary Network Logon.

The following is an example from the end of an SQLSTP.log file when this is the problem that is occurring:
22:00:29 End Action   ProcessAfterDataMove22:00:29 Begin Action BuildServer:22:00:29 Begin Action: CreateRegistrySetSQL22:00:29 End Action: CreateRegistrySetSQL22:00:29 Begin Action: RegWriteSetupEntry22:00:29 End Action: RegWriteSetupEntry22:00:29 Begin Action: CreateSer22:00:29 End Action: CreateSer22:00:29 Begin Action: SkuIt22:00:29 End Action: SkuIt22:00:30 Begin Action: UpdateSystemPath22:00:30 SetNewPath returned: 301022:00:30 Path successfully updated.22:00:30 End Action: UpdateSystemPath22:00:31 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe  -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 680 -U sa -P ###############################################################################Starting Service ...SQL_Latin1_General_CP1_CI_AS-m -Q -T4022 -T3659Connecting to Server ...driver={sql server};server= COMPUTERSNAME;UID=sa;PWD=;database=master					
You can also confirming if this problem is occurring by examining the SQL error log file to see if it is similar to this example:
2000-08-15 22:00:33.75 server    Microsoft SQL Server  2000 - 8.00.194 (Intel X86) 	Aug 6 2000 00:57:48 	Copyright (c) 1988-2000 Microsoft Corporation	Personal Edition on Windows 4.10 (Build 1998:  )2000-08-15 22:00:33.97 server    Copyright (C) 1988-2000 Microsoft Corporation.2000-08-15 22:00:34.01 server    All rights reserved.2000-08-15 22:00:34.04 server    Server Process ID is -144609.2000-08-15 22:00:34.07 server    Logging SQL Server messages in file 'C:\SQL Server\MSSQL\log\ERRORLOG'.2000-08-15 22:00:34.19 server    SQL Server is starting at priority class 'normal'(1 CPU detected).2000-08-15 22:00:34.60 server    User Mode Scheduler configured for thread processing2000-08-15 22:00:34.71 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks2000-08-15 22:00:35.13 spid3     Warning ******************2000-08-15 22:00:35.16 spid3     SQL Server started in single user mode. Updates allowed to system catalogs.2000-08-15 22:00:35.25 spid3     Starting up database 'master'.2000-08-15 22:00:36.88 spid3     Server name is COMPUTERSNAME.2000-08-15 22:00:36.93 spid3     Skipping startup of clean database id 42000-08-15 22:00:36.97 spid3     Skipping startup of clean database id 52000-08-15 22:00:37.00 spid3     Skipping startup of clean database id 62000-08-15 22:00:37.06 server    Using 'SSNETLIB.DLL' version '8.0.194'.2000-08-15 22:00:38.11 spid5     Clearing tempdb database.2000-08-15 22:00:38.28 server    Could not set up Net-Library 'SSNETLIB'.2000-08-15 22:00:38.35 server    Operating system error -1073723998: kaŒ.2000-08-15 22:00:38.44 server    Unable to load any netlibs.2000-08-15 22:00:38.53 server    SQL Server could not spawn FRunCM thread.					
A final way that reveals that this is the problem being encountered is if the following error message appears:
Microsoft Visual C++ runtime library
Assertion Failed
Program: C;\Windows\MMC.EXE
File: .q:\SPHINX\NETLIBS\nt\ssock\src\sqlsspi.c
Line: 124
Expression: Count
For information on how your program can cause an assertion failure, see the Vision C++ documentation on asserts
(Press retry to debug the application-JIT must be enabled)
hang lock freeze froze

Article ID: 229608 - Last Review: 10/26/2013 04:32:00 - Revision: 4.0

Microsoft SQL Server 7.0 Standard Edition, Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbbug kbpending KB229608