MSFT SQL Server - [решено] Не запускается служба SQL Server

MSFT SQL Server - [решено] Не запускается служба SQL Server

Techno88

Старожил

Сообщения: 251
Благодарности: 60

Профиль | Отправить PM | Цитировать

Здравствуйте!
Перестаёт запускаться служба SQL SERVER когда включаешь для нее протокол TCP/IP.

Логи SQL сервера:

Код:

Дата,Источник,Серьезность,Сообщение
11/29/2014 09:22:38,spid12s,Неизвестно,SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
11/29/2014 09:22:38,spid12s,Неизвестно,Error: 17120<c/> Severity: 16<c/> State: 1.
11/29/2014 09:22:38,spid12s,Неизвестно,Could not start the network library because of an internal error in the network library. To determine the cause<c/> review the errors immediately preceding this one in the error log.
11/29/2014 09:22:38,spid12s,Неизвестно,Error: 17826<c/> Severity: 18<c/> State: 3.
11/29/2014 09:22:38,spid12s,Неизвестно,TDSSNIClient initialization failed with error 0x2739<c/> status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. A protocol was specified in the socket function call that does not support the semantics of the socket type requested.
11/29/2014 09:22:38,spid12s,Неизвестно,Error: 17182<c/> Severity: 16<c/> State: 1.
11/29/2014 09:22:38,spid12s,Неизвестно,TDSSNIClient initialization failed with error 0x2739<c/> status code 0xa. Reason: Unable to initialize the TCP/IP listener. A protocol was specified in the socket function call that does not support the semantics of the socket type requested.
11/29/2014 09:22:38,spid12s,Неизвестно,Error: 17182<c/> Severity: 16<c/> State: 1.
11/29/2014 09:22:38,spid12s,Неизвестно,Server failed to listen on 'any' <ipv6> 0. Error: 0x2739. To proceed<c/> notify your system administrator.
11/29/2014 09:22:38,spid12s,Неизвестно,Error: 26024<c/> Severity: 16<c/> State: 1.
11/29/2014 09:22:38,spid12s,Неизвестно,A self-generated certificate was successfully loaded for encryption.
11/29/2014 09:22:38,spid9s,Неизвестно,The resource database build version is 11.00.2100. This is an informational message only. No user action is required.
11/29/2014 09:22:38,spid9s,Неизвестно,Starting up database 'mssqlsystemresource'.
11/29/2014 09:22:38,spid4s,Неизвестно,Starting up database 'msdb'.
11/29/2014 09:22:38,spid4s,Неизвестно,Failed to verify Authenticode signature on DLL 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\ftimport.dll'.
11/29/2014 09:22:38,spid4s,Неизвестно,Server name is 'PYATISTENOK\SQLEXPRESS'. This is an informational message only. No user action is required.
11/29/2014 09:22:38,spid4s,Неизвестно,SQL Trace ID 1 was started by login "sa".
11/29/2014 09:22:37,spid4s,Неизвестно,SQL Server Audit has started the audits. This is an informational message. No user action is required.
11/29/2014 09:22:37,spid4s,Неизвестно,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
11/29/2014 09:22:37,spid4s,Неизвестно,0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
11/29/2014 09:22:37,Сервер,Неизвестно,Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework\v4.0.30319\.
11/29/2014 09:22:37,spid4s,Неизвестно,2 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
11/29/2014 09:22:37,Server,Неизвестно,CLR version v4.0.30319 loaded.
11/29/2014 09:22:36,spid4s,Неизвестно,Starting up database 'master'.
11/29/2014 09:22:36,Сервер,Неизвестно,Software Usage Metrics is disabled.
11/29/2014 09:22:36,Сервер,Неизвестно,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.
11/29/2014 09:22:36,Сервер,Неизвестно,Node configuration: node 0: CPU mask: 0x0000000f:0 Active CPU mask: 0x0000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
11/29/2014 09:22:36,Сервер,Неизвестно,This instance of SQL Server last reported using a process ID of 1692 at 29.11.2014 9:11:20 (local) 29.11.2014 6:11:20 (UTC). This is an informational message only; no user action is required.
11/29/2014 09:22:36,Сервер,Неизвестно,Using conventional memory in the memory manager.
11/29/2014 09:22:36,Сервер,Неизвестно,Detected 2996 MB of RAM. This is an informational message; no user action is required.
11/29/2014 09:22:36,Сервер,Неизвестно,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
11/29/2014 09:22:36,Сервер,Неизвестно,SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket<c/> 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
11/29/2014 09:22:36,Server,Неизвестно,Command Line Startup Parameters:<nl/>	 -s "SQLEXPRESS"
11/29/2014 09:22:36,Server,Неизвестно,Registry startup parameters: <nl/>	 -d c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\master.mdf<nl/>	 -e c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log\ERRORLOG<nl/>	 -l c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
11/29/2014 09:22:36,Server,Неизвестно,The service account is 'WORKGROUP\PYATISTENOK$'. This is an informational message; no user action is required.
11/29/2014 09:22:36,Server,Неизвестно,Logging SQL Server messages in file 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
11/29/2014 09:22:36,Server,Неизвестно,Authentication mode is WINDOWS-ONLY.
11/29/2014 09:22:36,Server,Неизвестно,System Manufacturer: 'Acer'<c/> System Model: 'Aspire 5740'.
11/29/2014 09:22:36,Server,Неизвестно,Server process ID is 4184.
11/29/2014 09:22:36,Server,Неизвестно,All rights reserved.
11/29/2014 09:22:36,Server,Неизвестно,(c) Microsoft Corporation.
11/29/2014 09:22:36,Server,Неизвестно,Microsoft SQL Server 2012 - 11.0.2100.60 (Intel X86) <nl/>	Feb 10 2012 19:13:17 <nl/>	Copyright (c) Microsoft Corporation<nl/>	Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1<c/> v.178) (WOW64)
11/29/2014 09:11:28,spid9s,Неизвестно,Starting up database 'model'.
11/29/2014 09:11:28,spid12s,Неизвестно,SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
11/29/2014 09:11:28,spid12s,Неизвестно,Error: 17120<c/> Severity: 16<c/> State: 1.
11/29/2014 09:11:28,spid12s,Неизвестно,Could not start the network library because of an internal error in the network library. To determine the cause<c/> review the errors immediately preceding this one in the error log.
11/29/2014 09:11:28,spid12s,Неизвестно,Error: 17826<c/> Severity: 18<c/> State: 3.
11/29/2014 09:11:28,spid12s,Неизвестно,TDSSNIClient initialization failed with error 0x2739<c/> status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. A protocol was specified in the socket function call that does not support the semantics of the socket type requested.
11/29/2014 09:11:28,spid12s,Неизвестно,Error: 17182<c/> Severity: 16<c/> State: 1.
11/29/2014 09:11:28,spid12s,Неизвестно,TDSSNIClient initialization failed with error 0x2739<c/> status code 0xa. Reason: Unable to initialize the TCP/IP listener. A protocol was specified in the socket function call that does not support the semantics of the socket type requested.
11/29/2014 09:11:28,spid12s,Неизвестно,Error: 17182<c/> Severity: 16<c/> State: 1.
11/29/2014 09:11:27,spid12s,Неизвестно,Server failed to listen on 'any' <ipv6> 0. Error: 0x2739. To proceed<c/> notify your system administrator.
11/29/2014 09:11:27,spid12s,Неизвестно,Error: 26024<c/> Severity: 16<c/> State: 1.
11/29/2014 09:11:27,spid12s,Неизвестно,A self-generated certificate was successfully loaded for encryption.
11/29/2014 09:11:26,spid9s,Неизвестно,The resource database build version is 11.00.2100. This is an informational message only. No user action is required.
11/29/2014 09:11:26,spid9s,Неизвестно,Starting up database 'mssqlsystemresource'.
11/29/2014 09:11:26,spid3s,Неизвестно,Starting up database 'msdb'.
11/29/2014 09:11:26,spid3s,Неизвестно,Failed to verify Authenticode signature on DLL 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Binn\ftimport.dll'.
11/29/2014 09:11:26,spid3s,Неизвестно,Server name is 'PYATISTENOK\SQLEXPRESS'. This is an informational message only. No user action is required.
11/29/2014 09:11:25,spid3s,Неизвестно,SQL Trace ID 1 was started by login "sa".
11/29/2014 09:11:24,spid3s,Неизвестно,SQL Server Audit has started the audits. This is an informational message. No user action is required.
11/29/2014 09:11:24,spid3s,Неизвестно,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
11/29/2014 09:11:22,Server,Неизвестно,CLR version v4.0.30319 loaded.
11/29/2014 09:11:21,spid3s,Неизвестно,0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
11/29/2014 09:11:21,spid3s,Неизвестно,1 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
11/29/2014 09:11:21,spid3s,Неизвестно,Starting up database 'master'.
11/29/2014 09:11:20,Сервер,Неизвестно,Software Usage Metrics is disabled.
11/29/2014 09:11:20,Сервер,Неизвестно,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.
11/29/2014 09:11:20,Сервер,Неизвестно,Node configuration: node 0: CPU mask: 0x0000000f:0 Active CPU mask: 0x0000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
11/29/2014 09:11:20,Сервер,Неизвестно,This instance of SQL Server last reported using a process ID of 3468 at 26.11.2014 10:29:30 (local) 26.11.2014 7:29:30 (UTC). This is an informational message only; no user action is required.
11/29/2014 09:11:19,Сервер,Неизвестно,Using conventional memory in the memory manager.
11/29/2014 09:11:19,Сервер,Неизвестно,Detected 2996 MB of RAM. This is an informational message; no user action is required.
11/29/2014 09:11:19,Сервер,Неизвестно,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
11/29/2014 09:11:19,Сервер,Неизвестно,SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket<c/> 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
11/29/2014 09:11:17,Server,Неизвестно,Command Line Startup Parameters:<nl/>	 -s "SQLEXPRESS"
11/29/2014 09:11:17,Server,Неизвестно,Registry startup parameters: <nl/>	 -d c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\master.mdf<nl/>	 -e c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log\ERRORLOG<nl/>	 -l c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
11/29/2014 09:11:17,Server,Неизвестно,The service account is 'WORKGROUP\PYATISTENOK$'. This is an informational message; no user action is required.
11/29/2014 09:11:17,Server,Неизвестно,Logging SQL Server messages in file 'c:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
11/29/2014 09:11:17,Server,Неизвестно,Authentication mode is WINDOWS-ONLY.
11/29/2014 09:11:17,Server,Неизвестно,System Manufacturer: 'Acer'<c/> System Model: 'Aspire 5740'.
11/29/2014 09:11:17,Server,Неизвестно,Server process ID is 1692.
11/29/2014 09:11:17,Server,Неизвестно,All rights reserved.
11/29/2014 09:11:17,Server,Неизвестно,(c) Microsoft Corporation.
11/29/2014 09:11:17,Server,Неизвестно,Microsoft SQL Server 2012 - 11.0.2100.60 (Intel X86) <nl/>	Feb 10 2012 19:13:17 <nl/>	Copyright (c) Microsoft Corporation<nl/>	Express Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1<c/> v.178) (WOW64)

Отправлено: 09:27, 29-11-2014