SQL Server is terminating due to 'stop' request from Service Control Manager

Question

Post reply

SQL Server is terminating due to 'stop' request from Service Control Manager

vamshikrishnaeee

SSCrazy

Points: 2519
More actions
September 27, 2010 at 2:47 am

#145406

Hi all,
Today two sqlservices are stopped, but there is no clue in the error logs when I saw into event logs I found the following message :
" SQL Server is terminating due to 'stop' request from Service Control Manager"
If any one faced this kind of error plz help me on this.
Thanks,
Vamsy

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

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

I wouldnt say that that is an error. SqlServer has shutdown because it was requested to.

Is windows update running ? , check the windows event log for more pointers to the cause why.

Clear Sky SQL
My Blog[/url]

crazy4sql SSCoach Points: 19590 More actions · Answer 2

keep digging into application log and system log in event viewer of the system.

If its cluster check the cluster log.

----------
Ashish

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 3

Following were the messages from event log before sqlservice is stopped:

1. One of my backups failed due to following error :

The operating system returned the error '64(The specified network name is no longer available.)' while attempting 'FlushFileBuffers' on \\backupserver\..

2.Security policy in the Group policy objects has been applied successfully.

3.The MS DTC service is stopping.

4.Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.

5.FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.

6.SQLServerAgent service successfully stopped.

7.Then logins started failing and after some time sqlserver service is stopped.

Thanks,

Vamsy

crazy4sql SSCoach Points: 19590 More actions · Answer 4

3.The MS DTC service is stopping.

this made your sql services to be stopped.

You need to find out why the services get stopped.

----------
Ashish

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 5

There is no other messages related to why these sqlserver,sqlserver agent and msdtc had stopped in error and event logs. In event logs only the following message is there

" sqlserver is terminated due to stop request from service control manager".

Thanks,

Vamsy

Diane-238072 SSChasing Mays Points: 619 More actions · Answer 6

The message indicates that your SQL service was stopped from the Services Windows Management console (Administrative Tools > Services).

vamshikrishnaeee SSCrazy Points: 2519 More actions · Answer 7

No one had stopped the sqlserver service . All of our sqlserver services are stopping with message "sqlserver is terminating due to stop request from service control manager". We are not getting what made this service control manager to stop sqlserver.

Thanks,

Vamsy