SQL instance doesn't start up after a windows 10 PC goes into power saving mode

• ntsika

  SSC Journeyman

  Points: 97

  More actions

  April 7, 2017 at 3:23 am

  #323611

  Hi,

  We are having a problem here at work where a SQL instance is not running when we try to launch an application to connect to it. We have found out that this happens when the Windows 10 PC goes into power saving mode. example: The user will work in the application in the morning and then leave the computer for an hour or so. When they come back and try to launch the application they get an an error telling them the SQL server (xxxx) instance is no longer running. The helpdesk team usually just starts the instances without any errors.

  How do we go around making sure that this does not happen again?

  PS: The application is a desktop application so the 2012 Sqlexpress is local.

  Thank you

• Thom A

  SSC Guru

  Points: 99143

  More actions

  April 7, 2017 at 3:53 am

  #1937184

  Stop the PC going into power saving mode. This'll be in Control Panel->Hardware & Sound->Power Options and select High performance.

  On a related note, is this someone's normal desktop you're running SQL Express on, and are other people then accessing it from other desktops?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk