SQL SERVER ERROR 17148

[koolestj]

Hi. I would like to know all possible causes of the following error that appeared in the SQL Error log.
2003-10-29 10:28:30.12 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
Thanks!

 

[JamesLean]

At a guess, looks like someone used the Service Control Manager to stop the SQL service... ;-)

--James

 

[SQLBill]

By the way-in case you don't know, the Service Control Manager is one of the little icon that's on the tool bar by the clock. If it's not there, you can get to it via Start>Programs>Microsoft SQL Server>Service Control Manager.

-SQLBill

 

[koolestj]

Thanks for writing back. I asked this question because somehow our customer had an issue with our application that interfaces SQL Database through ODBC. Everything was going fine until the customer tried to run an event on the app that actually calls the odbc functions. Looking through the app evt log and sql error log.. I only see the error I posted 2003-10-29 10:28:30.12 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager. In the sql error log the code is 17148, w/c translates to the error in app evt log. Prior to that there are no indications of how this occurred.
The application tells me after the fact that there was an ODBC communication link failure but I would attribute that to SQL server shutdown.

 

[SQLBill]

Is this the only customer using this database? If so, in Enterprise Manager right click on the database, select properties, click on the Option tab and make sure Auto Close is NOT checked.

-SQLBill