SQL Server doesn't start - SQL Server Forums

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 doesn't start

Author

Topic

CanadaDBA

583 Posts

Posted - 2005-05-12 : 10:44:02

SQL Server on one of my local machines doesn't start. I tried to start it from command prompt. Here is the resullts:


C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr -dE:\Progra~1\Micros~1
\MSSQL\Data\master.mdf -lE:\Progra~1\Micros~1\MSSQL\Data\mastlog.ldf -eE:\Progra
~1\Micros~1\MSSQL\Data\ErrorLog
2005-05-12 11:36:48.90 server    Microsoft SQL Server  2000 - 8.00.818 (Intel X8
6)
        May 31 2003 16:08:15
        Copyright (c) 1988-2003 Microsoft Corporation
        Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2005-05-12 11:36:48.93 server    Copyright (C) 1988-2002 Microsoft Corporation.

2005-05-12 11:36:48.93 server    All rights reserved.
2005-05-12 11:36:48.93 server    Server Process ID is 1848.
2005-05-12 11:36:48.93 server    Logging SQL Server messages in file 'E:\Progra~
1\Micros~1\MSSQL\Data\ErrorLog'.
2005-05-12 11:36:49.00 server    SQL Server is starting at priority class 'norma
l'(1 CPU detected).
2005-05-12 11:36:49.45 server    SQL Server configured for thread mode processin
g.
2005-05-12 11:36:49.45 server    Using dynamic lock allocation. [500] Lock Block
s, [1000] Lock Owner Blocks.
2005-05-12 11:36:49.82 spid3     Starting up database 'master'.
2005-05-12 11:36:49.89 spid3     Error: 823, Severity: 24, State: 2.
2005-05-12 11:36:49.93 spid3     Error: 5180, Severity: 22, State: 1.

What is the problem? Do I need to reinstall the SQL Server?

Canada DBA

X002548
Not Just a Number

15586 Posts

Posted - 2005-05-12 : 10:50:40

Did you try to Google it?

http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

Brett

8-)

CanadaDBA

583 Posts

Posted - 2005-05-12 : 12:16:13

Ignore this post. I didn't noticed the date. It is from an old log.

In the ErrorLog, I noticed the following line:


2005-02-07 13:21:58.89 server    SQL server listening on 123.456.789.89: 1433.

While my IP address is changed from 123.456.789.89 to 123.456.789.103. How can I fix it?

Canada DBA

madness
Starting Member

13 Posts

Posted - 2005-05-12 : 17:53:54

You may need to stop and restart sql to allow it to bind on the new ip.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources