MSSQLSERVER Service cannot start [SQL 2000]

Hi All,
MSSQLSERVER Service is not started, when I try to start it, it tries to
start then it remains not started.
What are the possible causes of this issue?
What are the possible solutions other than reinstalling the SQL software?
Thank you.
BishoyTake a look at the SQL Server error log for the cause. The default location
for the logs is folder C:\Program Files\Microsoft SQL Server\MSSQL\LOG. The
most current file is ERRORLOG with no extention. There may also be related
messages in the event log.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||There are many possible causes, open a command window and navigate to where
the binary is and then issue the following
sqlservr -Con
This will start sql server up in a console and you can see the error
message.
You can find the Sql 2000 binary at
C:\Program Files\Microsoft SQL Server\MSSQL$InstanceName\Binn
or
C:\Program Files\Microsoft SQL Server\MSSQL\Binn
Your best bet for SQL 2005 is to check the event log or open up the error
log (it is plain text) and you can find it at
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\LOG
You can also start it at the command prompt like this
C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\binn\sqlservr.exe -m -f
where x is your instance number
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bishoy" <Bishoy@.discussions.microsoft.com> wrote in message
news:04183556-AC55-4230-B404-69D2F13D1A62@.microsoft.com...
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy|||Bishoy napisa?(a):
> Hi All,
> MSSQLSERVER Service is not started, when I try to start it, it tries to
> start then it remains not started.
> What are the possible causes of this issue?
> What are the possible solutions other than reinstalling the SQL software?
> Thank you.
> Bishoy
Hi chceck server service
regards
SW|||Hi,
Chk the Error log files and event viewer log files,
Chk for password if password is changed for service log on account.
Amol Lembhe
"SW" wrote:

> Bishoy napisa?(a):
> Hi chceck server service
> regards
> SW
>