he request failed or the service did not respond in a timely fashion.

Question

Post reply

he request failed or the service did not respond in a timely fashion.

patilharshalv

Mr or Mrs. 500

Points: 540
More actions
November 17, 2008 at 6:17 am

#154922

I am using MSSQL2005
when I restart the machine and trying to restart the SQl agent I get following error
"The request failed or the service did not respond in a timely fashion.
I can not start the server .
How to resolve this error?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Is it just the SQL Agent which does not start or the SQL Server?

Under which account are you trying to start the service?

The most likely reason for such an error is a logon failure for the service account, but if it's SQL Server which doesn't start it could also be a problem with the startup parameters. Check the eventlog for any other messages.

[font="Verdana"]Markus Bohse[/font]

patilharshalv Mr or Mrs. 500 Points: 540 More actions · Answer 2

YES ..

when I am trying to restart that I am getting that error

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

patilharshalv (11/17/2008)
YES ..
when I am trying to restart that I am getting that error

Yes what ??? You didn't answer any of my questions. Which service is having the problem, Which account are you using? Any other messages in the Eventlog ?

[font="Verdana"]Markus Bohse[/font]

patilharshalv Mr or Mrs. 500 Points: 540 More actions · Answer 4

In event log I get as

SQL Server evaluation period has expired.

and in some logs when the db was down I get the event log as

A page that should have been constant has changed (expected checksum: 73639977, actual checksum: 5b779837, database 17, file 'F:\MSSQL\GENERAL_MOTORS_DATA.mdf', page (1:213843)). This usually indicates a memory failure or other hardware or OS corruption.

what to do now?

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 5

patilharshalv (11/17/2008)
In event log I get as
SQL Server evaluation period has expired.
and in some logs when the db was down I get the event log as
A page that should have been constant has changed (expected checksum: 73639977, actual checksum: 5b779837, database 17, file 'F:\MSSQL\GENERAL_MOTORS_DATA.mdf', page (1:213843)). This usually indicates a memory failure or other hardware or OS corruption.
what to do now?

The first message tells it. You're using a evaluation version which has expired. You need to install a full version.

The second message could be caused by a hardwaare problem, most likely the harddisk. If you're lucky you can fix it using DBCC CHECKDB, but first you need replace the evaluation version.

[font="Verdana"]Markus Bohse[/font]

patilharshalv Mr or Mrs. 500 Points: 540 More actions · Answer 6

How to install install a full version.

I have data in that server how to restore that ?

sowmya.putrevu SSC Rookie Points: 25 More actions · Answer 7

sir i am also having the same problem i started using network services and local services but failed

ozzy_rkr SSC Enthusiast Points: 138 More actions · Answer 8

I had this same error, and i found this topic when i googled it. however i found nothing related to it in the event log.

I remember that I've changed the administrator account password after i setup the SQL server and configured the instance access. so i ran SQL server configuration manager, and changed the password for the SQL server instance, and for the SQL server Agent as well.