cancel
Showing results for 
Search instead for 
Did you mean: 

Getting this message in the logs 'Database Server shutdown due to machine shutdown'

Former Member
0 Kudos

Hi I'm working at a clients site and they have and installation that is receiving tis message in the log and the SQL Anywhere is shutting down.

I've went looking through all the system logs and events and cannot find any indication as to what is requesting this.

Does anyone have any idea or suggestion

Terry

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Terry,

What OS is the server running on? Is SQL Anywhere server running as Windows service? If this is a pre-Vista Windows and the service is allowed to interact with desktop, a Windows user signing off sends a KILL signal to the process (same as when machine is reboot/turned off) and this will log engine is shutting down due to machine shutdown.

If that's the case, unchecking the option should do the trick.

Former Member
0 Kudos

Thanks for the quick reply

Windows server 2003 it is running on, Ill check if it has been bought up this way. What is the parameter if the service has been started from a commandline.

Terry

Former Member
0 Kudos

Hi Terry,

Typically you wouldn't start a Windows service from command prompt, but it's:

dbsvc -u <service_name>

Run dbsvc -g <service_name> and see if this returns "Allowed to interact with desktop"

former_member182948
Active Participant
0 Kudos

Hi,

In this case, your issue would be solved in the following procedure.

  1. Open the Windows Service Management Console (services.msc)
  2. Select the SQL Anywhere Service
  3. Right-click and select 'Properties'
  4. Under the 'Log On' tab, uncheck the option 'Allow service to interact with desktop' 

Thanks

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks guys

I think this has isolated it, switched this off and we are monitoring

Terry