Microsoft KB Archive/229608

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

Article ID: 229608

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition, when used with:
 * Microsoft Windows 98 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q229608



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



SYMPTOMS
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

File: ..\SRC\SQLSSPI.C

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: 1 ods     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: 3010 11: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.



CAUSE
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".



WORKAROUND
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:  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\MSSQLServer

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 7.0

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent 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. 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. 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.</li> 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.</li> Reinstall SQL Server 7.0.</li></ol>

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.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

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:

<pre class="fixed_text">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:

<pre class="fixed_text">22:00:29 End Action  ProcessAfterDataMove 22:00:29 Begin Action BuildServer: 22:00:29 Begin Action: CreateRegistrySetSQL 22:00:29 End Action: CreateRegistrySetSQL 22:00:29 Begin Action: RegWriteSetupEntry 22:00:29 End Action: RegWriteSetupEntry 22:00:29 Begin Action: CreateSer 22:00:29 End Action: CreateSer 22:00:29 Begin Action: SkuIt 22:00:29 End Action: SkuIt 22:00:30 Begin Action: UpdateSystemPath 22:00:30 SetNewPath returned: 3010 22:00:30 Path successfully updated. 22:00:30 End Action: UpdateSystemPath 22: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 -T3659

Connecting 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:

<pre class="fixed_text">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 processing 2000-08-15 22:00:34.71 server   Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks 2000-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 4 2000-08-15 22:00:36.97 spid3    Skipping startup of clean database id 5 2000-08-15 22:00:37.00 spid3    Skipping startup of clean database id 6 2000-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)

Additional query words: hang lock freeze froze

Keywords: kbbug kbpending KB229608

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.