Sql Server 2000 service is not starting

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)

Sql Server 2000 service is not starting

Author

Topic

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 12:47:44

Hi,
I have a personal version of sql 2000 and also a personal version of sql 2005 on my machine. Both were working fine. However recently the sql 2000 service is not starting. Is there any way to get this resolved without having to reinstall the sql 2000?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-26 : 12:49:09

is it throwing any error? what happen when you try to start it manually?

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 12:49:33

Can you start it manually? (Programs : Administrator tools : Services - find the Microsoft SQL Service and try starting it)

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 12:50:44

Also, worth looking in the SQL Log. That is a file that you can view with Notepad etc. Usually in the LOGS folder under wherever SQL put the rest of its database files etc. Probably under Program Files : Microsoft SQL Server : ... if it was a SQL 2000 default install

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 12:51:31

Thanks visakh16 and Kristen.

I am going to the service manager and clicking the start. As soon as it starts the service stops.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-26 : 12:51:58

quote:
Originally posted by Kristen

Can you start it manually? (Programs : Administrator tools : Services - find the Microsoft SQL Service and try starting it)

by 24 s

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 12:57:24

OK in the service manager
In the services window I could start sql server manually. However I do not know if this is assocaited with sql server 2005 or sql server 2000.

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 12:58:52

"by 24 s"

Don't rub it in !!

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 12:59:23

Also when I am trying to register the sql server 2000 it gives error message as: sql server does not exist or access denied.

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 13:00:55

SQL 2000 service is called "MSSQLSERVER"

SQL 2005 is called "SQL Server(MSSQLSERVER)"

They could have made them more obvious!

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 13:04:29

OK then I got the right one which is mssqlserver.

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 13:11:07

Anything in the log file (its called ERRORLOG and is usually in the LOG folder, as explained above). There will also be files ERRORLOG.1, ERRORLOG.2, ... which will be for the previous times that SQL Server was closed.

Note that back in the SERVICES program there is an option to autostart the service (when Windows starts) if you want to turn that on.

Is the service still running? (or did it stop, by itself, already?)

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 13:16:09

Here is the error log.
Service is still running:
2010-01-26 12:00:41.62 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2010-01-26 12:00:41.62 server Copyright (C) 1988-2002 Microsoft Corporation.
2010-01-26 12:00:41.62 server All rights reserved.
2010-01-26 12:00:41.62 server Server Process ID is 5028.
2010-01-26 12:00:41.62 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2010-01-26 12:00:41.68 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2010-01-26 12:00:42.31 server SQL Server configured for thread mode processing.
2010-01-26 12:00:42.31 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2010-01-26 12:00:42.32 spid3 Starting up database 'master'.
2010-01-26 12:00:42.47 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2010-01-26 12:00:42.47 spid5 Starting up database 'model'.
2010-01-26 12:00:42.48 spid3 Server name is 'USILDEK1-21001'.
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 4
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 5
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 6
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 7
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 8
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 9
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 10
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 11
2010-01-26 12:00:42.48 spid3 Skipping startup of clean database id 12
2010-01-26 12:00:42.48 server SQL server listening on 10.193.120.227: 1433.
2010-01-26 12:00:42.48 server SQL server listening on 127.0.0.1: 1433.
2010-01-26 12:00:42.53 server SQL server listening on TCP, Shared Memory, Named Pipes.
2010-01-26 12:00:42.53 server SQL Server is ready for client connections
2010-01-26 12:00:42.57 spid5 Error: 9003, Severity: 20, State: 1
2010-01-26 12:00:42.57 spid5 The LSN (6:196:1) passed to log scan in database 'model' is invalid..

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 13:17:07

Sorry the service automatically stopped

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 13:20:34

Hmmm ... the ERRORLOG is all normal ... except the last line:

2010-01-26 12:00:42.57 spid5 The LSN (6:196:1) passed to log scan in database 'model' is invalid..

I wonder if the SQL 2005 "Model" database has installed where the SQL 2000 one used to be?

Not sure how to recover this I'm afraid.

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 13:22:44

Thanks Kristen May be it is time for a new sql 2000 install.

Kristen
Test

22859 Posts

Posted - 2010-01-26 : 13:27:41

I've cross posted to the Data Corruption forum
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138888
You may want to hang on and see if someone who knows about database corruption can help.

My recollection is that to install SQL 2000 and SQL 2005 on the same machine then SQL 2000 has to be installed first. I'm not sure if that would mean that you would have problems trying to re-install SQL 2000 - not that SQL 2005 is installed on that machine.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-26 : 13:57:45

Restore a backup of model. The transaction log is corrupt. There is a procedure for restoring the system databases, check in Books Online. (I don't have the 2000 BoL installed).

If you don't have a backup, you can rebuild the master database. I think that rebuilds model as well (no guarantee)
You may want to get hold of someone who knows SQL relatively well if you don't. This isn't trivial stuff.

--
Gail Shaw
SQL Server MVP

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-26 : 14:00:29

quote:
Originally posted by KristenI wonder if the SQL 2005 "Model" database has installed where the SQL 2000 one used to be?

If that were the case, the errors would be far more interesting.

--
Gail Shaw
SQL Server MVP

gamaz
Posting Yak Master

104 Posts

Posted - 2010-01-26 : 14:12:41

Thanks Kristena and Gail for the help. I am going to research and find out about restoring master etc here.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-01-26 : 14:21:50

Not restoring master. Restoring model from backup.

It's only if you don't have a backup of model that you beed to consider rebuilding (not restoring) master

--
Gail Shaw
SQL Server MVP

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources