Install issues with SQL 2K and WIN2K server SP2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Install issues with SQL 2K and WIN2K server SP2

Author

Topic

hurler16
Starting Member

8 Posts

Posted - 2002-06-26 : 16:04:10

I'm trying to install SQL 2K on a WIN2K server with SP2
installed. Everything goes fine until I get the box that
reads "starting the server and installing your chosen
configuration". At this point, the install hangs. I've
tried to go back in and uninstall, and it won't let me
(says the uninstall file is corrupt or missing) I tried
installing a new instance, but that hung as well. I've
attached the beginning of the error log. Does anyone know
what is causing this? I'm about rip what little hair I
have out. Thanks.

2002-06-26 16:26:50.14 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

2002-06-26 16:26:50.15 server Copyright (C) 1988-2000 Microsoft Corporation.
2002-06-26 16:26:50.15 server All rights reserved.
2002-06-26 16:26:50.15 server Server Process ID is 2564.
2002-06-26 16:26:50.15 server Logging SQL Server messages in file 'F:\Program Files\Microsoft SQL Server J\MSSQL$JOKER1\log\ERRORLOG'.
2002-06-26 16:26:50.17 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2002-06-26 16:26:50.20 server SQL Server configured for thread mode processing.
2002-06-26 16:26:50.21 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2002-06-26 16:26:50.23 server Attempting to initialize Distributed Transaction Coordinator.
2002-06-26 16:26:52.31 spid3 Warning ******************
2002-06-26 16:26:52.31 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2002-06-26 16:26:52.31 spid3 Starting up database 'master'.
2002-06-26 16:26:52.48 spid3 Server name is 'FUSERVE-WWFES\JOKER1'.
2002-06-26 16:26:52.48 server Using 'SSNETLIB.DLL' version '8.0.194'.
2002-06-26 16:26:52.48 spid5 Starting up database 'model'.
2002-06-26 16:26:52.48 spid7 Starting up database 'msdb'.
2002-06-26 16:26:52.48 spid8 Starting up database 'pubs'.
2002-06-26 16:26:52.51 spid9 Starting up database 'Northwind'.
2002-06-26 16:26:52.64 server Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to F:\Program Files\Microsoft SQL Server J\MSSQL$JOKER1\log\SQL00001.dmp
2002-06-26 16:26:52.68 server SqlDumpExceptionHandler: Process 1828 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
*******************************************************************************
*

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-26 : 16:38:11

Can you post SQLSTP.log

Thanks,

-Chad

hurler16
Starting Member

8 Posts

Posted - 2002-06-26 : 17:19:02

Sure Chad. It won't fit on the forum, but here's a link to it
http://www.secretweaponstudios.com/sqlstp.txt

thanks

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-26 : 17:41:53

Sorry, asked for the wrong thing

how about cnfgsvr.out.

-Chad

hurler16
Starting Member

8 Posts

Posted - 2002-06-26 : 18:05:49

Hmm, don't have any file with that name? Any other file that may help you?

Paul

quote:

Sorry, asked for the wrong thing how about cnfgsvr.out.

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-26 : 18:53:37

Are you running setup on the physical machine? Or are you using terminal sevices (Or some other remote admin software) ?

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-26 : 19:02:44

Use the following article to completely remove SQL from your machine:

http://support.microsoft.com/support/kb/articles/q290/9/91.asp

Now restart setup from a command line, and ad the following switch (Withou quotes) "k=dbg"

When it gets to the part about "Do you want to configure the server" open another command prompt, go to your binn directory and start SQL
"c:\> sqlservr" then try to connect using QA.

If it starts and connects, stop SQL (Hit cntl-C on the cmd prompt where you started it) then proceed with the install (Say yes to configuring the server).

HTH
-Chad

hurler16
Starting Member

8 Posts

Posted - 2002-06-26 : 19:30:18

Thanks Chad. I am using terminal services to control the server. I'm also installing from the hard drive, not a CD. I've tried that article already, but it still hangs when it tries to install, so I'm back at square one again with the install :( Shall I try installing from the command line now anyway? Thanks for your help.

Paul

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-27 : 01:15:52

Completley remove SQL via the article. Try and install on the physical machine. I seem to remember that Terminal Services is not supported for installing SQL, though that may be just 7.0

-Chad

chadmat
The Chadinator

1974 Posts

Posted - 2002-06-27 : 01:20:59

Okay,

I just looked it up. That was only 7.0 that didn't work over TS. Try the command line method I suggested above.

-Chad

hurler16
Starting Member

8 Posts

Posted - 2002-06-27 : 01:51:10

I'm going to try the command line method in a few. Lucky TS is supported in SQL2K.....I'm in Boston and the server is in Texas :(

hurler16
Starting Member

8 Posts

Posted - 2002-06-27 : 14:45:25

How do I specify an instance when trying to start sqlservr from the command line? Thanks