none
新安装的SQL Server 2014 服务无法启动 RRS feed

  • 问题

  • 今天在WIN10在安装SQL SERVER 2012和2014都无法正常启动。

    ---------------------------
    SQL Server 配置管理器
    ---------------------------
    请求失败或服务未及时响应。有关详细信息,请参见事件日志或其他适用的错误日志。
    ---------------------------
    确定   
    ---------------------------

    2016年7月30日 5:11

全部回复

  • 请问下载的sqlserver2014是什么版本

    安装的过程中有没有问题?


    Love SQL

    2016年7月30日 7:08
  • 请问下载的sqlserver2014是什么版本

    安装的过程中有没有问题?


    Love SQL

    安装最后提示数据库引擎启动失败。
    2016年7月30日 7:44
  • 那就是安装过程中就已经出问题了

    建议看看安装日志

    xx:\Program Files\Microsoft SQL Server\xx\Setup Bootstrap\Log

    xx部分为你的安装路径


    Love SQL

    2016年7月30日 7:46
  • What's sql service account?
    2016年7月30日 16:32
  • 那就是安装过程中就已经出问题了

    建议看看安装日志

    xx:\Program Files\Microsoft SQL Server\xx\Setup Bootstrap\Log

    xx部分为你的安装路径


    Love SQL

    现在基本能明确问题所在了。

    系统安装 KB3173428 补丁后,服务就启动不了。

    而这个补丁无法删除,求解决办法!

    2016年7月31日 15:25
  • What's sql service account?

    现在基本能明确问题所在了。

    系统安装 KB3173428 补丁后,服务就启动不了。

    而这个补丁无法删除,求解决办法!


    2016年7月31日 15:25
  • Better to contact MS support for the solution.
    2016年7月31日 17:56
  • 补丁是可以删除的,在控制面板的添加删除程序,系统功能,左边有个系统更新选项卡,列出系统中已经安装的更新,选中它把它删除即可。


    专注于.NET ERP/CRM开发框架,C/S架构,SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms

    2016年8月1日 0:23
  • 日志中查到是什么错误信息
    2016年8月1日 1:38
  • 这个补丁是删除不了,从已安装的更新中。
    2016年8月1日 1:45
  • 日志中查到是什么错误信息

    2016-07-31 22:04:36.79 Server      Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
    Feb 10 2012 19:39:15 
    Copyright (c) Microsoft Corporation
    Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

    2016-07-31 22:04:36.79 Server      (c) Microsoft Corporation.
    2016-07-31 22:04:36.79 Server      All rights reserved.
    2016-07-31 22:04:36.79 Server      Server process ID is 2828.
    2016-07-31 22:04:36.80 Server      System Manufacturer: 'LENOVO', System Model: '20BVA02SCD'.
    2016-07-31 22:04:36.80 Server      Authentication mode is MIXED.
    2016-07-31 22:04:36.80 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2016-07-31 22:04:36.80 Server      The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
    2016-07-31 22:04:36.81 Server      Registry startup parameters: 
    -d C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2016-07-31 22:04:36.82 Server      Command Line Startup Parameters:
    -s "MSSQLSERVER"
    2016-07-31 22:04:37.19 服务器         SQL Server detected 1 sockets with 2 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
    2016-07-31 22:04:37.19 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2016-07-31 22:04:37.19 服务器         Detected 7888 MB of RAM. This is an informational message; no user action is required.
    2016-07-31 22:04:37.19 服务器         Using conventional memory in the memory manager.
    2016-07-31 22:04:37.65 服务器         This instance of SQL Server last reported using a process ID of 2192 at 2016/7/30 21:48:21 (local) 2016/7/30 13:48:21 (UTC). This is an informational message only; no user action is required.
    2016-07-31 22:04:37.65 服务器         Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2016-07-31 22:04:37.66 服务器         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.
    2016-07-31 22:04:37.71 服务器         Software Usage Metrics is disabled.
    2016-07-31 22:04:37.73 spid5s      Starting up database 'master'.
    2016-07-31 22:04:37.82 Server      CLR version v4.0.30319 loaded.
    2016-07-31 22:04:37.89 spid5s      Resource governor reconfiguration succeeded.
    2016-07-31 22:04:37.89 spid5s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2016-07-31 22:04:37.89 spid5s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2016-07-31 22:04:37.93 spid5s      SQL Trace ID 1 was started by login "sa".
    2016-07-31 22:04:37.94 spid5s      Server name is 'DESKTOP-A61GETO'. This is an informational message only. No user action is required.
    2016-07-31 22:04:37.95 spid5s      Failed to verify Authenticode signature on DLL 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\ftimport.dll'.
    2016-07-31 22:04:37.95 spid5s      Starting up database 'msdb'.
    2016-07-31 22:04:37.95 spid9s      Starting up database 'mssqlsystemresource'.
    2016-07-31 22:04:37.96 spid9s      The resource database build version is 11.00.2100. This is an informational message only. No user action is required.
    2016-07-31 22:04:37.98 spid13s     A self-generated certificate was successfully loaded for encryption.
    2016-07-31 22:04:37.98 spid13s     Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    2016-07-31 22:04:37.99 spid13s     Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
    2016-07-31 22:04:37.99 spid9s      Starting up database 'model'.
    2016-07-31 22:04:37.99 服务器         Server is listening on [ ::1 <ipv6> 1434].
    2016-07-31 22:04:37.99 服务器         Server is listening on [ 127.0.0.1 <ipv4> 1434].
    2016-07-31 22:04:37.99 服务器         Dedicated admin connection support was established for listening locally on port 1434.
    2016-07-31 22:04:38.00 spid13s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2016-07-31 22:04:38.00 服务器         SQL Server is attempting to register a Service Principal Name (SPN) for the SQL Server service. Kerberos authentication will not be possible until a SPN is registered for the SQL Server service. This is an informational message. No user action is required.
    2016-07-31 22:04:38.00 服务器         The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/DESKTOP-A61GETO ] for the SQL Server service. Windows return code: 0xffffffff, state: 63. Failure to register a SPN might cause integrated authentication to use NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies and if the SPN has not been manually registered.
    2016-07-31 22:04:38.02 spid9s      Clearing tempdb database.
    2016-07-31 22:04:38.17 服务器         Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2016-07-31 22:04:38.20 spid9s      Starting up database 'tempdb'.
    2016-07-31 22:04:38.34 spid16s     The Service Broker endpoint is in disabled or stopped state.
    2016-07-31 22:04:38.35 spid16s     The Database Mirroring endpoint is in disabled or stopped state.
    2016-07-31 22:04:38.36 spid16s     Service Broker manager has started.
    2016-07-31 22:04:38.36 spid5s      Recovery is complete. This is an informational message only. No user action is required.
    2016-07-31 23:00:40.91 服务器         SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
    2016-07-31 23:00:43.44 spid16s     Service Broker manager has shut down.
    2016-07-31 23:00:43.44 spid16s     Error: 17054, Severity: 16, State: 1.
    2016-07-31 23:00:43.44 spid16s     The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
    2016-07-31 23:00:43.44 spid5s      .NET Framework runtime has been stopped.
    2016-07-31 23:00:43.48 spid5s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

    2016年8月1日 1:54
  • Looks like due to os rebooting around 11pm.
    2016年8月1日 15:37
  • Hi Yonghua_Andy,

    我建议你参考下面几个注意点:

    1: 是否已管理员进行安装。

    2: 对SQL Server 2014 升级到最新版本(SP2)。

    3: 设置防火墙允许SQL Server相关操作。

    Best Regards,

    Yohann Lu

    2016年8月6日 7:12
  • 依然无法解决。
    2016年9月26日 2:03