Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Не запускается сервис SQL Server 2014 Express  [new]
kuarse
Member

Откуда:
Сообщений: 11
Здравствуйте, профессионалы!

Помогите разобраться с проблемой сабж.

в логе сервера:
+
2017-05-27 20:18:29.41 Server Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1) (Hypervisor)

2017-05-27 20:18:29.41 Server UTC adjustment: 4:00
2017-05-27 20:18:29.41 Server (c) Microsoft Corporation.
2017-05-27 20:18:29.41 Server All rights reserved.
2017-05-27 20:18:29.41 Server Server process ID is 2516.
2017-05-27 20:18:29.41 Server Authentication mode is MIXED.
2017-05-27 20:18:29.41 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2017-05-27 20:18:29.41 Server The service account is 'SqlServer\User'. This is an informational message; no user action is required.
2017-05-27 20:18:29.41 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2017-05-27 20:18:29.41 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2017-05-27 20:18:30.30 Server SQL Server detected 2 sockets with 1 cores per socket and 1 logical processors per socket, 2 total logical processors; using 1 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2017-05-27 20:18:30.30 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-05-27 20:18:30.30 Server Detected 3071 MB of RAM. This is an informational message; no user action is required.
2017-05-27 20:18:30.30 Server Using conventional memory in the memory manager.
2017-05-27 20:18:30.34 Server Default collation: Cyrillic_General_CI_AS (русский 1049)
2017-05-27 20:18:30.34 Server Ошибка: 25607, серьезность: 17, состояние: 1.
2017-05-27 20:18:30.34 Server The Extended Event engine has been disabled by startup options. Features that depend on Extended Events may fail to start.
2017-05-27 20:18:30.42 Server Query Store settings initialized with enabled = 1,
2017-05-27 20:18:30.47 Server This instance of SQL Server last reported using a process ID of 1116 at 27.05.2017 20:18:29 (local) 27.05.2017 16:18:29 (UTC). This is an informational message only; no user action is required.
2017-05-27 20:18:30.47 Server The maximum number of dedicated administrator connections for this instance is '1'
2017-05-27 20:18:30.47 Server Node configuration: node 0: CPU mask: 0x00000001:0 Active CPU mask: 0x00000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2017-05-27 20:18:30.47 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2017-05-27 20:18:30.52 Server Software Usage Metrics is disabled.
2017-05-27 20:18:30.52 spid9s Starting up database 'master'.
2017-05-27 20:18:30.64 Server CLR version v4.0.30319 loaded.
2017-05-27 20:18:30.77 spid9s 1 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-27 20:18:30.86 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework\v4.0.30319\.
2017-05-27 20:18:30.86 spid9s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-27 20:18:31.12 spid9s SQL Server Audit failed to start, and the server is being shut down. To troubleshoot this issue, use the -m flag (Single User Mode) to bypass Audit-generated shutdowns when the server is starting.


Поиск в инете о:
Ошибка: 25607, серьезность: 17, состояние: 1.
SQL Server Audit failed to start, and the server is being shut down
27 май 17, 19:29    [20517296]     Ответить | Цитировать Сообщить модератору
 Re: Не запускается сервис SQL Server 2014 Express  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31355
kuarse
Помогите разобраться с проблемой сабж.
Так он вам пишет, что нужно сделать, в этой же строке.
27 май 17, 21:04    [20517371]     Ответить | Цитировать Сообщить модератору
 Re: Не запускается сервис SQL Server 2014 Express  [new]
kuarse
Member

Откуда:
Сообщений: 11
alexeyvg,

пробовал, та же ошибка
+
2017-05-27 22:21:30.57 Server Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86)
Feb 20 2014 19:20:46
Copyright (c) Microsoft Corporation
Express Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1) (Hypervisor)

2017-05-27 22:21:30.57 Server UTC adjustment: 4:00
2017-05-27 22:21:30.59 Server (c) Microsoft Corporation.
2017-05-27 22:21:30.59 Server All rights reserved.
2017-05-27 22:21:30.59 Server Server process ID is 1592.
2017-05-27 22:21:30.59 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.
2017-05-27 22:21:30.59 Server Authentication mode is MIXED.
2017-05-27 22:21:30.59 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2017-05-27 22:21:30.59 Server The service account is 'ThinApp\User'. This is an informational message; no user action is required.
2017-05-27 22:21:30.59 Server Registry startup parameters:
-d C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf
-e C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2017-05-27 22:21:30.59 Server Command Line Startup Parameters:
-m
2017-05-27 22:21:31.44 Server SQL Server detected 2 sockets with 1 cores per socket and 1 logical processors per socket, 2 total logical processors; using 1 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2017-05-27 22:21:31.44 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-05-27 22:21:31.44 Server Detected 3071 MB of RAM. This is an informational message; no user action is required.
2017-05-27 22:21:31.44 Server Using conventional memory in the memory manager.
2017-05-27 22:21:31.49 Server Default collation: Cyrillic_General_CI_AS (русский 1049)
2017-05-27 22:21:31.49 Server Ошибка: 25607, серьезность: 17, состояние: 1.
2017-05-27 22:21:31.49 Server The Extended Event engine has been disabled by startup options. Features that depend on Extended Events may fail to start.
2017-05-27 22:21:31.49 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
2017-05-27 22:21:31.54 Server Query Store settings initialized with enabled = 1,
2017-05-27 22:21:31.58 Server The maximum number of dedicated administrator connections for this instance is '1'
2017-05-27 22:21:31.58 Server This instance of SQL Server last reported using a process ID of 1152 at 27.05.2017 22:18:56 (local) 27.05.2017 18:18:56 (UTC). This is an informational message only; no user action is required.
2017-05-27 22:21:31.58 Server Node configuration: node 0: CPU mask: 0x00000001:0 Active CPU mask: 0x00000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2017-05-27 22:21:31.60 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2017-05-27 22:21:31.63 Server Database Mirroring Transport is disabled in the endpoint configuration.
2017-05-27 22:21:31.63 Server Software Usage Metrics is disabled.
2017-05-27 22:21:31.63 spid9s Warning ******************
2017-05-27 22:21:31.63 spid9s SQL Server started in single-user mode. This an informational message only. No user action is required.
2017-05-27 22:21:31.63 spid9s Starting up database 'master'.
2017-05-27 22:21:31.68 spid9s 1 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-27 22:21:31.68 spid9s 0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2017-05-27 22:21:31.85 Server CLR version v4.0.30319 loaded.
2017-05-27 22:21:32.00 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework\v4.0.30319\.
2017-05-27 22:21:32.02 spid9s SQL Server Audit failed to start, and the server is being shut down. To troubleshoot this issue, use the -m flag (Single User Mode) to bypass Audit-generated shutdowns when the server is starting.

27 май 17, 21:27    [20517390]     Ответить | Цитировать Сообщить модератору
 Re: Не запускается сервис SQL Server 2014 Express  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31355
kuarse
пробовал, та же ошибка
Вот, похоже, рецепт: https://blogs.msdn.microsoft.com/sql_shep/2012/07/19/sql-2012-security-audit-3-predicate-and-failure/
27 май 17, 23:27    [20517560]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить