Installation of SQL 7.0 Desktop Edition Locks up on Win 98 Machine

Installation of SQL 7.0 Desktop Edition Locks up on Win 98 Machine

Post by A.G. Pennypacke » Sun, 02 May 1999 04:00:00

Hi List:

I am a newbie to this list and SQL Server, so please forgive me if this is a
FAQ-ish question.  I am trying to install the Desktop Edition of SQL Server
7.0 on a Win 98 machine (Celeron 333a with cache, 64mb ram, lots of free
hard disk space).  The Desktop Edition is supposed to be compatible with Win
9x platforms, albeit with limited functionality.  I have attempted to
install the software several times, and every time I try it the installation
program locks up during the "Connecting to Server" stage, where the
documentation says that the SQL server is being configured by running some
scripts.  There appears to be little or no hard disk activity occurring, and
I have let the thing stew for a good 45 minutes to an hour with no evidence
of any progress beyond this point.  I have stopped the install by
ctrl-alt-del'ing, and deleted the directories and registry entries created
to that point, and tried reinstalling several times.  I have disabled all
programs such as Norton AV that run at startup, as recommended by MS, and
still the same thing happens every time.  I checked the MS Knowledge Base
but didn't find anything helpful.

Has anyone else run into this problem?  Is the installation really failing,
or am I just not waiting long enough for the server to configure itself?
As I said, I've waited almost an hour with no success.

Any suggestions are much appreciated, please reply to this group or email me


aka A.G.
aka Martin Van Nostrand


Installation of SQL 7.0 Desktop Edition Locks up on Win 98 Machine

Post by Neil Pik » Mon, 03 May 1999 04:00:00

Quote:> Subject: Installation of SQL 7.0 Desktop Edition Locks up on Win 98 Machine

Q.     I'm having trouble installing SQL Server on Win9x.  What could be going
(v1.0 1999.02.28)

A.  Try the following check-list of things that could go wrong - these are
specific to Win9x and SQL 7.  You may also want to look at the generic install
FAQ entry.

1.  Make sure the machine is of the required spec to run the version of SQL you
are installing.  I.e. if it is SQL EE then make sure you have NT EE.  For SQL 7
you need a 100% Intel pentium compatible chip or an Alpha etc.  There is a
full-list in another faq entry.

2.  You have to install Microsoft Client for Networks via the Network applet in
Control Panel.  It must also be your primary network logon.  Once SQL 7 is
installed then it doesn't need to be your Primary Network Logon.

3.  If you are upgrading make sure that the default database for the "sa" login
is master.

4.  If the problem is to do with ODBC files not installing, then check that
nothing has the ODBC files open.  It could also be that the ODBC files on your
hard-drive have been marked as read-only.  Check with ATTRIB.EXE or explorer to
see if this is the case.

5.  Check the *.OUT files in the <sql>\install directory for clues as to what
is going on.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see (library 1) - latest stuff is always here


1. Pure Windows 98 Installation - SQL 7.0 Desktop won't install

I'm not able to install SQL Server 7.0 (Desktop edition) on a pure Win98
installation (nothing else is installed on the mashine).

Here are my problems :

1) When I try "typical" install, after a while setup asks for the "HTML Help
Disk" which I can't locate in my package.

2) I formated the hard disk, reinstalled WIN 98, selected a "Custom" SQl
Server install and unchecked the "Books On Line". This time I didn't had the
"HTML Help Disk" problem, but the installation wasn't able to finish. It
stucked in a "Connecting to Server..." window and Windows Task Manager
responded that SQL Desktop was not responding.

3) I restarted the mashine and performed a new SQL Server installation
selecting the same options as the previous one (note that I didn't uninstall
the previous installation because Control Panel responded that the unisntall
info was corrupted)

4) This time everything seemed to be finish fine. I restarted the mashine,
started the MSSQL Service and loaded Enterprise Manager

My problem is that when I'm trying to browse the SQL Server Contents, it
responds with the message
Assertion failed.
File ../src/sqlsspi.c
Line 119

Expression count.

Any ideas ?



George Kontogiannis
Athens, Greece


Greece, land of the Gods.
Sea and Sun are our birthrights.


1. Remove <NO_SPAM_> to access my real E-Mail Address
2. AVOID the above E-Mail for questions/answers. Use this
   newsgroup so everyone can benefit.



3. Installation of SQL Server 7 Desktop Edition on Windows 98 - PROBLEM

4. Export to Excel?

5. Installation hangs SQL 7 Win 98 Desktop Version

6. Novell Client32 and Db conection lost

7. URGENT - Installing Desktop Edition on Win 98

8. Using Delphi with a version control system

9. Installing Desktop Edition on Win 98

10. URGENT - Installing Desktop Edition on Win 98

11. Connect to Desktop Edition on Win 98

12. Problem during installation of SQL Server 7.0 Desktop Edition on Win98

13. Installation of SQL 7.0 desktop edition