none
Служба SQL Server завершается самопроизвольно RRS feed

  • Вопрос

  • Установил SQL Server 2016 Express. Периодически приходится заново стартовать службу, т.к. она оказывается остановленной. В Event Log ничего не получилось найти. Как диагностировать проблему?
    • Перемещено Alexander RusinovModerator 13 августа 2016 г. 18:06 Более подходящий раздел форума
    11 августа 2016 г. 13:51

Ответы

Все ответы

  • Что тут случилось? Вроде бы заврешение не аварийное.  Вот последние строки:

    2016-08-09 16:18:05.77 spid5s      Execution of POST_SQLAGENT100.SQL complete
    2016-08-09 16:18:05.77 spid5s      ------------------------------------------
    2016-08-09 16:18:05.77 spid5s      ------------------------------------
    2016-08-09 16:18:05.77 spid5s      Moving 2005 SSIS Data to 2008 tables
    2016-08-09 16:18:05.77 spid5s      ------------------------------------
    2016-08-09 16:18:05.77 spid5s      Mapping SSIS yukon roles to katmai roles...
    2016-08-09 16:18:05.79 spid5s      Moving package folders...
    2016-08-09 16:18:05.79 spid5s      Moving packages...
    2016-08-09 16:18:05.79 spid5s      Moving logs...
    2016-08-09 16:18:05.80 spid5s      Dropping yukon stored procedures...
    2016-08-09 16:18:05.85 spid5s      Dropping yukon tables...
    2016-08-09 16:18:05.86 spid5s      Creating sysdtslog90 view...
    2016-08-09 16:18:05.86 spid5s      Database name 'tempdb' ignored, referencing object in tempdb.
    2016-08-09 16:18:05.90 spid5s      Database name 'tempdb' ignored, referencing object in tempdb.
    2016-08-09 16:18:05.93 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.93 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.93 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.93 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.93 spid5s      Executing msdb.dbo.sp_syspolicy_create_purge_job
    2016-08-09 16:18:05.94 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.94 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.94 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.94 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.96 spid5s      post_dc100::Enabling Agent XPs before restoring data collector original state
    2016-08-09 16:18:05.96 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.96 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.97 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.97 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:05.97 spid5s      Data Collector Status
    2016-08-09 16:18:05.97 spid5s      CollectorEnabled:0
    2016-08-09 16:18:05.97 spid5s      Collection set status
    2016-08-09 16:18:05.97 spid5s      Uid:7B191952-8ECF-4E12-AEB2-EF646EF79FEF, Name:Disk Usage, IsRunning:0
    2016-08-09 16:18:05.97 spid5s      Uid:49268954-4FD4-4EB6-AA04-CD59D9BB5714, Name:Server Activity, IsRunning:0
    2016-08-09 16:18:05.97 spid5s      Uid:2DC02BD6-E230-4C05-8516-4E8C0EF21F95, Name:Query Statistics, IsRunning:0
    2016-08-09 16:18:05.97 spid5s      Uid:ABA37A22-8039-48C6-8F8F-39BFE0A195DF, Name:Utility Information, IsRunning:0
    2016-08-09 16:18:05.97 spid5s      post_dc100::uploading instmdw.sql to msdb ...
    2016-08-09 16:18:05.97 spid5s      Uploading instmdw.sql from disk: C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\Install\instmdw.sql
    2016-08-09 16:18:06.08 spid5s      Loaded 1332596 bytes from 'C:\Program Files\Microsoft SQL Server\MSSQL13.SQLEXPRESS\MSSQL\Install\instmdw.sql'
    2016-08-09 16:18:06.44 spid5s      post_dc100::Checking if collection set status were captured in temp table...
    2016-08-09 16:18:06.44 spid5s      post_dc100::Restoring collection set running status...
    2016-08-09 16:18:06.44 spid5s      post_dc100::Checking if Data collector was enabled before upgrade...
    2016-08-09 16:18:06.44 spid5s      post_dc100::Current data collector state is same as pre-upgrade state
    2016-08-09 16:18:06.44 spid5s      Data Collector Status
    2016-08-09 16:18:06.44 spid5s      CollectorEnabled:0
    2016-08-09 16:18:06.44 spid5s      Collection set status
    2016-08-09 16:18:06.44 spid5s      Uid:7B191952-8ECF-4E12-AEB2-EF646EF79FEF, Name:Disk Usage, IsRunning:0
    2016-08-09 16:18:06.44 spid5s      Uid:49268954-4FD4-4EB6-AA04-CD59D9BB5714, Name:Server Activity, IsRunning:0
    2016-08-09 16:18:06.44 spid5s      Uid:2DC02BD6-E230-4C05-8516-4E8C0EF21F95, Name:Query Statistics, IsRunning:0
    2016-08-09 16:18:06.44 spid5s      Uid:ABA37A22-8039-48C6-8F8F-39BFE0A195DF, Name:Utility Information, IsRunning:0
    2016-08-09 16:18:06.46 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:06.46 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:06.46 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:06.46 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:06.65 spid5s      Restored implicit transactions state to OFF
    2016-08-09 16:18:06.68 spid5s      Upgrading Database Mail related objects...
    2016-08-09 16:18:07.15 spid5s      Completed upgrade of Database Mail related objects...
    2016-08-09 16:18:07.21 spid5s      Database 'master' is upgrading script 'upgrade_ucp_cmdw_discovery.sql' from level 218105409 to level 218105957.
    2016-08-09 16:18:07.21 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.21 spid5s      Starting execution of UPGRADE_UCP_CMDW_DISCOVERY.SQL
    2016-08-09 16:18:07.21 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.27 spid5s      The Utility MDW does not exist on this instance.
    2016-08-09 16:18:07.27 spid5s      User 'sa' is changing database script level entry 15 to a value of 500.
    2016-08-09 16:18:07.27 spid5s      Skipping the execution of instmdw.sql.
    2016-08-09 16:18:07.27 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.27 spid5s      execution of UPGRADE_UCP_CMDW_DISCOVERY.SQL completed
    2016-08-09 16:18:07.27 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.40 spid5s      Database 'master' is upgrading script 'ssis_discovery' from level 218105409 to level 218105957.
    2016-08-09 16:18:07.40 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.40 spid5s      Starting execution of SSIS_DISCOVERY.SQL
    2016-08-09 16:18:07.40 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.46 spid5s      Database SSISDB does not exist in current SQL Server instance
    2016-08-09 16:18:07.46 spid5s      User 'sa' is changing database script level entry 17 to a value of 500.
    2016-08-09 16:18:07.46 spid5s      Database SSISDB could not be upgraded successfully.
    2016-08-09 16:18:07.46 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.46 spid5s      Execution of SSIS_DISCOVERY.SQL completed
    2016-08-09 16:18:07.46 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.54 spid5s      Database 'master' is upgrading script 'SSIS_hotfix_install.sql' from level 218105409 to level 218105957.
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.57 spid5s      Starting execution of SSIS_HOTFIX_INSTALL.SQL         
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.57 spid5s      Database SSISDB does not exist in current SQL Server instance
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.57 spid5s      Execution of SSIS_HOTFIX_INSTALL.SQL completed
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.57 spid5s      Database 'master' is upgrading script 'provision_ceipsvc_account.sql' from level 218105409 to level 218105957.
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.57 spid5s      Start provisioning of CEIPService Login       
    2016-08-09 16:18:07.57 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.58 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2016-08-09 16:18:07.58 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.58 spid5s      Ending provisioning of CEIPLoginName.       
    2016-08-09 16:18:07.58 spid5s      ------------------------------------------------------
    2016-08-09 16:18:07.58 spid5s      SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2016-08-09 16:18:07.60 spid5s      Recovery is complete. This is an informational message only. No user action is required.
    2016-08-09 16:18:08.61 spid5s      SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    2016-08-09 16:18:08.69 spid5s      .NET Framework runtime has been stopped.
    2016-08-09 16:18:09.58 spid5s      SQL Server shutdown has been initiated
    2016-08-09 16:18:09.58 spid5s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

    12 августа 2016 г. 9:39
  • Судя по логу лучше переустановить...


    MS,MCTS,MCP,MCPD: SharePoint Developer 2010


    • Изменено Maxim Shusharin 12 августа 2016 г. 10:42 синтаксис
    12 августа 2016 г. 10:42
  • Не исключено, что вместе с ОС... Такое поведение иногда встречается на инфицированных машинах
    13 августа 2016 г. 10:37
  • После перезагрузки служба снова отключается. Может ил это быть из-за того, что сервер запущен в однопользовательском режиме? Как его переключить в многопользовательский? Может ли быть виновен Reporting, которому не удается войти на сервер? В каком порядке производить переустановку win10, vs2015, sdt, ms sql 2016, GDR и CU для MS SQL?
    13 августа 2016 г. 13:57
  • Попробуйте отключить репортинг и проверить
    • Помечено в качестве ответа Энтомолог 15 августа 2016 г. 14:46
    14 августа 2016 г. 7:06
  • У меня с 2014 такая же проблема была на другом компьютере. Установил SP2 на 2014. Отключил всё в Configuration Manager, кроме службы SQL Server, дал учетке админские права, перезапустился, вернул права обратно. Теперь после перезагрузки 2014 не отключается.
    15 августа 2016 г. 14:46
  • В 2016 Express отключение остальных служб не помогло.
    15 августа 2016 г. 15:10