SQL Server Does Not Start

[Isaac Rajan]

Hello,

I have installed MSDE2000A on a standalone PC with Win ME O/s. The PC
was earlier used on a Lan and has a Lan card. I could install a named
instance of the server successfully but the server does not start when
I attempt to start it using the service manager.

Could you tell me how this could be solved?

Thanks in advance.

Isaac

[Erland Sommarskog]

Isaac Rajan (is********@yahoo.com) writes:

I have installed MSDE2000A on a standalone PC with Win ME O/s. The PC
was earlier used on a Lan and has a Lan card. I could install a named
instance of the server successfully but the server does not start when
I attempt to start it using the service manager.

Could you tell me how this could be solved?

Check the Windows event log for messages. Check also the LOG directory
of SQL Server; the file ERRORLOG if there is any message. Don't forget
to check the date of ERRORLOG. If this date does not agree with the
time you tried to start SQL Server, it never came that far.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Isaac Rajan]

Erland,

Thank you very much for the reply. How do I check the logs you mentioned?

TIA.

Isaac

Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn*********************@127.0.0.1>...

Isaac Rajan (is********@yahoo.com) writes:

I have installed MSDE2000A on a standalone PC with Win ME O/s. The PC
was earlier used on a Lan and has a Lan card. I could install a named
instance of the server successfully but the server does not start when
I attempt to start it using the service manager.

Could you tell me how this could be solved?

Check the Windows event log for messages. Check also the LOG directory
of SQL Server; the file ERRORLOG if there is any message. Don't forget
to check the date of ERRORLOG. If this date does not agree with the
time you tried to start SQL Server, it never came that far.

[Erland Sommarskog]

Isaac Rajan (is********@yahoo.com) writes:

Thank you very much for the reply. How do I check the logs you mentioned?

To check the Windows event log, you find the eventlog viewer under
Administrative Tools on the start menu. The most likely place to find
something is the Application log. Check for messages from the MSSQL
Server service, but also the Service Control Manager.

The SQL Server errorlog is a plain text plain; you can view it any editor.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp