Solved

Error when installing SQL Server 7.0 Beta 3

Posted on 1998-10-27
2
355 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

626 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