系统日志报错：
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 (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' 1433].
2020-01-19 09:32:42.39 spid10s Server is listening on [ 'any' 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 1434].
2020-01-19 09:32:42.39 服务器 Server is listening on [ 127.0.0.1 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完全控制权限
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
