none
SQL Server(MSSQLSERVER)服务无法启动,请问问题出在哪里 RRS feed

  • 问题

  • 系统日志报错:

    SQL Server (MSSQLSERVER) 服务由于下列服务特定错误而终止:
    找不到映像文件中指定的资源名。

    SQL Server日志文件报错

    2020-01-19 09:32:41.96 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: ) (Hypervisor)

    2020-01-19 09:32:41.96 Server      (c) Microsoft Corporation.
    2020-01-19 09:32:41.96 Server      All rights reserved.
    2020-01-19 09:32:41.96 Server      Server process ID is 700.
    2020-01-19 09:32:41.96 Server      System Manufacturer: 'Alibaba Cloud', System Model: 'Alibaba Cloud ECS'.
    2020-01-19 09:32:41.96 Server      Authentication mode is MIXED.
    2020-01-19 09:32:41.96 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2020-01-19 09:32:41.96 Server      The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
    2020-01-19 09:32:41.96 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
    2020-01-19 09:32:41.96 Server      Command Line Startup Parameters:
         -s "MSSQLSERVER"
    2020-01-19 09:32:42.07 服务器         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.
    2020-01-19 09:32:42.07 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2020-01-19 09:32:42.07 服务器         Detected 7918 MB of RAM. This is an informational message; no user action is required.
    2020-01-19 09:32:42.07 服务器         Using conventional memory in the memory manager.
    2020-01-19 09:32:42.19 服务器         This instance of SQL Server last reported using a process ID of 1640 at 2020/1/19 9:31:36 (local) 2020/1/19 1:31:36 (UTC). This is an informational message only; no user action is required.
    2020-01-19 09:32:42.20 服务器         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.
    2020-01-19 09:32:42.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.
    2020-01-19 09:32:42.22 spid5s      Starting up database 'master'.
    2020-01-19 09:32:42.24 spid5s      29 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
    2020-01-19 09:32:42.26 spid5s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
    2020-01-19 09:32:42.30 Server      CLR version v4.0.30319 loaded.
    2020-01-19 09:32:42.31 spid5s      Resource governor reconfiguration succeeded.
    2020-01-19 09:32:42.31 spid5s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2020-01-19 09:32:42.31 spid5s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2020-01-19 09:32:42.34 spid5s      SQL Trace ID 1 was started by login "sa".
    2020-01-19 09:32:42.35 spid5s      Server name is 'iZhbuqq1d6ox80Z'. This is an informational message only. No user action is required.
    2020-01-19 09:32:42.36 服务器         Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
    2020-01-19 09:32:42.39 spid10s     A self-generated certificate was successfully loaded for encryption.
    2020-01-19 09:32:42.39 spid10s     Server is listening on [ 'any' <ipv6> 1433].
    2020-01-19 09:32:42.39 spid10s     Server is listening on [ 'any' <ipv4> 1433].
    2020-01-19 09:32:42.39 spid10s     Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    2020-01-19 09:32:42.39 spid10s     Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
    2020-01-19 09:32:42.39 服务器         Server is listening on [ ::1 <ipv6> 1434].
    2020-01-19 09:32:42.39 服务器         Server is listening on [ 127.0.0.1 <ipv4> 1434].
    2020-01-19 09:32:42.39 服务器         Dedicated admin connection support was established for listening locally on port 1434.
    2020-01-19 09:32:42.39 spid10s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2020-01-19 09:32:42.39 服务器         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.
    2020-01-19 09:32:42.40 服务器         The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZhbuqq1d6ox80Z ] 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.
    2020-01-19 09:32:42.40 服务器         The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/iZhbuqq1d6ox80Z:1433 ] 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.
    2020-01-19 09:32:42.49 spid11s     A new instance of the full-text filter daemon host process has been successfully started.
    2020-01-19 09:32:42.58 spid15s     Starting up database 'EstarCompetition'.
    2020-01-19 09:32:42.58 spid14s     Starting up database 'msdb'.
    2020-01-19 09:32:42.58 spid6s      Starting up database 'mssqlsystemresource'.
    2020-01-19 09:32:42.58 spid16s     Starting up database 'EstarCompetition_Test'.
    2020-01-19 09:32:42.59 spid6s      The resource database build version is 11.00.2100. This is an informational message only. No user action is required.
    2020-01-19 09:32:42.63 spid6s      Starting up database 'model'.
    2020-01-19 09:32:42.66 spid6s      Clearing tempdb database.
    2020-01-19 09:32:42.66 spid6s      Error: 5123, Severity: 16, State: 1.
    2020-01-19 09:32:42.66 spid6s      CREATE FILE encountered operating system error 5(拒绝访问。) while attempting to open or create the physical file 'D:\SqlServerAutomaticBak\DATA'.
    2020-01-19 09:32:42.67 spid6s      Error: 17204, Severity: 16, State: 1.
    2020-01-19 09:32:42.67 spid6s      FCB::Open failed: Could not open file D:\SqlServerAutomaticBak\DATA for file number 1.  OS error: 5(拒绝访问。).
    2020-01-19 09:32:42.67 spid6s      Error: 5120, Severity: 16, State: 101.
    2020-01-19 09:32:42.67 spid6s      Unable to open the physical file "D:\SqlServerAutomaticBak\DATA". Operating system error 5: "5(拒绝访问。)".
    2020-01-19 09:32:42.67 spid6s      Error: 1802, Severity: 16, State: 4.
    2020-01-19 09:32:42.67 spid6s      CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
    2020-01-19 09:32:42.67 spid6s      Could not create tempdb. You may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server. Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.
    2020-01-19 09:32:42.67 spid6s      SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    2020-01-19 09:32:43.71 spid6s      Error: 25725, Severity: 16, State: 1.
    2020-01-19 09:32:43.71 spid6s      An error occurred while trying to flush all running Extended Event sessions.  Some events may be lost.

    已经对D:\SqlServerAutomaticBak\DATA添加了everyone完全控制权限和MSSQLSERVER完全控制权限,


    2020年1月19日 1:51

全部回复

  • 问题解决了,说一下问题产生的原因,临时数据库tempdb占有磁盘空间太大了,我更改了一下位置

    更改位置的时候只选择了地址,没有设置文件名,导致了这个错误

    使用cmd开启服务,然后重新设置正确的文件地址后解决问题

    2020年1月19日 5:57
  • I am so glad to hear that you have resolved your issue. Please mark your solution as answer. This can be beneficial to other community members reading the thread.

    In addition, if you have another questions, please feel free to ask.

    Thanks for your contribution.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月20日 2:56