Solved

Error when installing SQL Server 7.0 Beta 3

Posted on 1998-10-27
2
316 Views
Last Modified: 2011-09-20
When installing SQL Server 7.0 BETA 3

I run the setup program from the CD-rom. And begin installing the desktop and typical version.
The installation program installs the files, then MDAC, MMC, MSDTC, HTML Help, and
ActiveX Components. After the installing of activeX components the Installation program show a
Message saying ”Starting Service” (I think to initiate server) after a while I get the first error message:
A message-box appears and shows the following line
in the title-line of message-box:
  Microsoft Visual C++ Runtime Library
It contains:
  Assertion failed!
  Program: C:\MSSQL7\BINN\CNFGSVR.EXE
  File: ../src/sqlsspi.c
  Line 119
 
  Expression: Count

  For information on how your program can cause an assertion
  failure, see the Visual C++ documetation on asserts

  (Press  retry to debug the application - JIT must be
  enabled
End of message box.....

Then this message-box appears:
  The title-line shows: Sql Server setup
And the box contains:
  Setup failed to configure SQL-Server. Refer to the
  SQL-Server error logs and cnfgsvr.out for more information
End of error box...

Then I get kicked out of the installation program.

The contents of cnfgsvr.out after the non successful installation:

Starting Service ...
Connecting to Server ...
driver={sql server};server=DEFAULT;UID=sa;PWD=;database=master

The error log contains the following information:
98/10/12 23:35:37.38 kernel   Microsoft SQL Server  7.00 - 7.00.517 (Intel X86)
      Jun 19 1998 17:06:54
      Copyright (c) 1988-1998 Microsoft Corporation
      Desktop version on Windows

98/10/12 23:35:37.42 kernel   Copyright (C) 1988-1997 Microsoft Corporation.
98/10/12 23:35:37.42 kernel   All rights reserved.
98/10/12 23:35:37.42 kernel   Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
98/10/12 23:35:37.53 kernel   initconfig: Number of user connections limited to 32767.
98/10/12 23:35:37.58 kernel   SQL Server is starting at priority class 'normal'(1 CPU detected).
98/10/12 23:35:37.68 server   Performance monitor shared memory setup failed: -1
98/10/12 23:35:37.75 kernel   User Mode Scheduler configured for thread processing
98/10/12 23:35:39.21 server   Directory Size: 5396
98/10/12 23:35:39.30 spid1    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
98/10/12 23:35:39.41 spid1    Warning ******************
98/10/12 23:35:39.42 spid1    SQL Server started in single user mode. Updates allowed to system catalogs.
98/10/12 23:35:39.42 spid1    Warning ******************
98/10/12 23:35:39.42 spid1    Recovering only master database
98/10/12 23:35:39.50 spid1    Starting up database 'master'.
98/10/12 23:35:39.51 spid1    Opening file C:\MSSQL7\data\master.mdf.
98/10/12 23:35:39.62 spid1    Opening file C:\MSSQL7\data\mastlog.ldf.
98/10/12 23:35:39.93 spid1    Loading SQL Server's  Unicode collation.
98/10/12 23:35:40.03 spid1    Loading SQL Server's  non-Unicode sort order and character set.
98/10/12 23:35:40.43 spid1    15 transactions rolled forward in database 'master' (1).
98/10/12 23:35:40.44 spid1    0 transactions rolled back in database 'master' (1).
98/10/12 23:35:40.76 spid1    Server is unnamed.
98/10/12 23:35:40.76 kernel   Using 'SQLEVN70.DLL' version '7.00.517'.
98/10/12 23:35:40.82 kernel   Using 'OPENDS60.DLL' version '7.00.00.0517'.
98/10/12 23:35:40.95 ods      Using 'SSMSSH70.DLL' version '7.098/10/12 23:35:40.99 spi98/10/12 23:35:41.07 ods      Using 'SSMSS98/10/12 23:35:41.10 spid1    SQL Server's non-Un98/10/12 23:35:41.19 ods      Using 'SSMSRP70.DLL' version '7.0.517' to listen on 'DEFAULT'.
98/10/12 23:35:41.19 spid1            'nocase_iso' (ID = 52).
98/10/12 23:35:41.49 spid1    SQL Server's non-Unicode character set is:
98/10/12 23:35:41.61 spid1            'iso_1' (ID = 1).
98/10/12 23:35:41.72 kernel   Warning: override, autoexec procedures skipped.
98/10/12 23:35:42.13 ods      Error: 17826, Severity: 18, State: 1
98/10/12 23:35:42.13 ods      Could not set up ListenOn connection 'DEFAULT'..
98/10/12 23:35:42.12 ods      ,



Do you have any idea of what may cause this problem and how I can fix it?

Microsoft does not want to help!!!!

Hope to hear from somebody soon.

To your info: I have from before installed:
Access97, FrontPage98, Microsoft Personal Web Server.

 
0
Comment
Question by:erot
2 Comments
 
LVL 2

Accepted Solution

by:
formula earned 200 total points
ID: 1090829
This is the same error message as I received when I was attempting to install 7.0 beta on a WIN 98 standalone computer.
If that's what you're doing, here's your solution.  If not you can reject my answer.

Solution:
Right click on Network Neighborhood and view the Properties. Check on the Configuration tab and ensure that a network client like "Client for Microsoft Networks" is installed.  If not, use the add button and add the network client. After this is installed you should be able to successfully install SQL Server Beta 3 on your Windows 95/98 platform.

0
 

Author Comment

by:erot
ID: 1090830
 It worked.....
  Thank you ....you have earned another extra 100 points!!!

  Erot
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now