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|||This is a multi-part message in MIME format.
--050904070208030402070600
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
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
--050904070208030402070600
Content-Type: text/x-vcard; charset=utf-8;
name="sebwax.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="sebwax.vcf"
YmVnaW46dmNhcmQNCmZuOlMgVw0KbjpXO1MNCmVtYWlsO2ludGVybmV0OnNlYndheChub3Nw
YW0pQGludGVyaWEucGwNCnZlcnNpb246Mi4xDQplbmQ6dmNhcmQNCg0K
--050904070208030402070600--|||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 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
>

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.

Bishoy

Check your system and application event log for error messages from sql server. You find event log viewer in Start->Control Panel->Administrative Tools->Event viewer or by starting "eventvwr" from Start->Run...

Do you see any messages from MSSQLServer or Service Control Manager?

--
SvenC

|||

Hi Bishoy,

The most elementary test which you can do is that verify that in the Service Manager, the login details are correct. Possible cause : Change in Domain account password.

If you are using SP3 or lower update, download latest Service Pack (SP4) from the microsoft download site. There is a KB article on it and this bug has been fixed in SP4 (http://support.microsoft.com/kb/840856)

Let me know if you are not able to resolve the issue.

Regards,

Rajesh

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.
Bishoy
Take 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
|||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
>

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
>

MSSQL6.5 'Golden'/Rollback state problem

Hi, anyone knows if the 'golden' / rollback state in sql
6.5 causes the entire server to hang is a known problem?
Are there any advices as to what can be done to avoid
this problem from occurring in the future again? ThanksHi Kimkia.
Golden state applies to spids, not the server - so there is no direct
relationship I can see between a spid in golden and the server hanging. A
spid in golden state could cause an individual database to be inaccessible
but as far as I know, this shouldn't affect the whole server. Then again,
6.5 seems like a distant memory these days for me so perhaps someone else
could chip in with some more information for you.
As far as avoiding golden state is concerned - you should apply normal
deadlock / rollback avoidance techniques - keeping transactions short,
indexes up to date (to help keep transactions short & avoid deadlocks),
inspect regular deadlocks for coding mistakes such as accessing tables in
opposite orders. Also avoid doing major batch work in busy periods so that
you won't have to roll back large transactions during busy periods (during
which spids go golden)
HTH
Regards,
Greg Linwood
SQL Server MVP
"Kimkia" <ahkimkia@.hotmail.com> wrote in message
news:051d01c39dc3$ba897520$a601280a@.phx.gbl...
> Hi, anyone knows if the 'golden' / rollback state in sql
> 6.5 causes the entire server to hang is a known problem?
> Are there any advices as to what can be done to avoid
> this problem from occurring in the future again? Thanks