Name State OwnerGroup ResourceType ------------------------------- Analysis Services Online SQL Server (MSSQLSERVER) Generic Service dtc Online dtc Network Name IP 地址 192.168.3.184 Online dtc IP Address MSDTC-dtc Online dtc Distributed Transaction Coordinator SQL IP Address 1 (MSSQLSERVER) Online SQL Server (MSSQLSERVER) IP Address SQL Network Name (MSSQLSERVER) Online SQL Server (MSSQLSERVER) Network Name SQL Server Online SQL Server (MSSQLSERVER) SQL Server SQL Server Agent Online SQL Server (MSSQLSERVER) SQL Server Agent SQL Server Analysis Services CEIP Online SQL Server (MSSQLSERVER) Generic Service SQL Server CEIP (MSSQLSERVER) Online SQL Server (MSSQLSERVER) Generic Service SQL Server Polybase Dms (MSSQLSERVER) Online SQL Server (MSSQLSERVER) Generic Service SQL Server Polybase Engine (MSSQLSERVER) Online SQL Server (MSSQLSERVER) Generic Service 存储 Qos 资源 Online 群集组 Storage QoS Policy Manager 群集 IP 地址 Online 群集组 IP Address 群集磁盘1 Online 群集组 Physical Disk 群集磁盘2 Online SQL Server (MSSQLSERVER) Physical Disk 群集磁盘3 Online dtc Physical Disk 群集名称 Online 群集组 Network Name
2024-07-19 23:14:40.39 Server Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)
2024-07-19 23:14:40.40 Server UTC adjustment: 8:00 2024-07-19 23:14:40.40 Server (c) Microsoft Corporation. 2024-07-19 23:14:40.41 Server All rights reserved. 2024-07-19 23:14:40.41 Server Server process ID is 6560. 2024-07-19 23:14:40.41 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware7,1'. 2024-07-19 23:14:40.41 Server Authentication mode is MIXED. 2024-07-19 23:14:40.41 Server Logging SQL Server messages in file 'F:\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2024-07-19 23:14:40.41 Server The service account is 'SJ\administrator'. This is an informational message; no user action is required. 2024-07-19 23:14:40.41 Server Registry startup parameters: -d F:\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf -e F:\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG -l F:\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2024-07-19 23:14:40.41 Server Command Line Startup Parameters: -s "MSSQLSERVER" 2024-07-19 23:14:40.42 Server SQL Server detected 2 sockets with 2 cores per socket and 2 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. 2024-07-19 23:14:40.42 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2024-07-19 23:14:40.42 Server Detected 4095 MB of RAM. This is an informational message; no user action is required. 2024-07-19 23:14:40.42 Server Using conventional memory in the memory manager. 2024-07-19 23:14:40.47 Server Default collation: Chinese_PRC_CI_AS (简体中文 2052) 2024-07-19 23:14:40.50 Server Buffer pool extension is already disabled. No action is necessary. 2024-07-19 23:14:40.53 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled. 2024-07-19 23:14:40.53 Server Implied authentication manager initialization failed. Implied authentication will be disabled. 2024-07-19 23:14:40.55 Server The maximum number of dedicated administrator connections for this instance is '1' 2024-07-19 23:14:40.55 Server This instance of SQL Server last reported using a process ID of 2412 at 2024/7/19 23:14:24 (local) 2024/7/19 15:14:24 (UTC). This is an informational message only; no user action is required. 2024-07-19 23:14:40.55 Server 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. 2024-07-19 23:14:40.56 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. 2024-07-19 23:14:40.56 Server Database Instant File Initialization: 已启用. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required. 2024-07-19 23:14:40.57 Server Query Store settings initialized with enabled = 1, 2024-07-19 23:14:40.57 spid4s Starting up database 'master'. 2024-07-19 23:14:40.66 Server CLR version v4.0.30319 loaded. 2024-07-19 23:14:40.71 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\. 2024-07-19 23:14:40.85 spid4s Resource governor reconfiguration succeeded. 2024-07-19 23:14:40.85 spid4s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2024-07-19 23:14:40.85 spid4s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2024-07-19 23:14:41.15 spid4s SQL Trace ID 1 was started by login "sa". 2024-07-19 23:14:41.18 spid4s Server name is 'MSSQLSERVER'. This is an informational message only. No user action is required. 2024-07-19 23:14:41.18 spid4s The NETBIOS name of the local node that is running the server is 'SJ02'. This is an informational message only. No user action is required. 2024-07-19 23:14:41.25 spid10s A self-generated certificate was successfully loaded for encryption. 2024-07-19 23:14:41.29 spid10s Server is listening on [ 192.168.3.185 </i><ipv4> 1433]. 2024-07-19 23:14:41.29 spid10s Started listening on virtual network name 'MSSQLSERVER'. No user action is required. 2024-07-19 23:14:41.29 spid10s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2024-07-19 23:14:41.29 spid10s Server named pipe provider is ready to accept connection on [ \\.\pipe\$$\MSSQLSERVER\sql\query ]. 2024-07-19 23:14:41.29 spid10s SQL Server is now ready for client connections. This is an informational message; no user action is required. 2024-07-19 23:14:41.29 Server 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. 2024-07-19 23:14:41.32 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com ] for the SQL Server service. 2024-07-19 23:14:41.32 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com:1433 ] for the SQL Server service. 2024-07-19 23:14:41.57 spid12s A new instance of the full-text filter daemon host process has been successfully started. 2024-07-19 23:14:41.60 spid4s Database mirroring has been enabled on this instance of SQL Server. 2024-07-19 23:14:41.60 spid19s Always On: The availability replica manager is starting. This is an informational message only. No user action is required. 2024-07-19 23:14:41.60 spid16s Starting up database 'msdb'. 2024-07-19 23:14:41.60 spid19s Always On Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required. 2024-07-19 23:14:41.60 spid18s Starting up database 'DWConfiguration'. 2024-07-19 23:14:41.61 spid17s Starting up database 'DWDiagnostics'. 2024-07-19 23:14:41.61 spid6s Starting up database 'mssqlsystemresource'. 2024-07-19 23:14:41.61 spid20s Starting up database 'DWQueue'. 2024-07-19 23:14:41.61 spid21s Starting up database 'ipmsprod'. 2024-07-19 23:14:41.61 spid19s Always On Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to start. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On Availability Groups: Local Windows Server Failover Clustering node started. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On Availability Groups: Local Windows Server Failover Clustering node is online. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required. 2024-07-19 23:14:41.61 spid19s Always On: The local replica of availability group 'ag-ipmsprod' is starting. This is an informational message only. No user action is required. 2024-07-19 23:14:41.64 spid6s The resource database build version is 13.00.4001. This is an informational message only. No user action is required. 2024-07-19 23:14:41.64 spid19s The state of the local availability replica in availability group 'ag-ipmsprod' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'. The state changed because the local instance of SQL Server is starting up. For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log. 2024-07-19 23:14:41.67 spid21s Error: 35262, Severity: 17, State: 1. 2024-07-19 23:14:41.67 spid21s Skipping the default startup of database 'ipmsprod' because the database belongs to an availability group (Group ID: 65536). The database will be started by the availability group. This is an informational message only. No user action is required. 2024-07-19 23:14:41.85 spid6s Starting up database 'model'. 2024-07-19 23:14:42.29 spid6s Polybase feature initialization successful, hadoop connectivity 0x7, node role: 0x1. 2024-07-19 23:14:42.29 spid6s Clearing tempdb database. 2024-07-19 23:14:42.30 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:14:42.30 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:14:42.32 spid4s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required. 2024-07-19 23:14:42.46 Server Software Usage Metrics is enabled. 2024-07-19 23:14:42.85 spid6s Starting up database 'tempdb'. 2024-07-19 23:14:43.53 spid6s The tempdb database has 4 data file(s). 2024-07-19 23:14:43.53 spid6s TEMPDB configuration for Polybase completed successfully. 2024-07-19 23:14:43.53 spid28s The Service Broker endpoint is in disabled or stopped state. 2024-07-19 23:14:43.56 spid28s Server is listening on [ 192.168.3.185 </i><ipv4> 5022]. 2024-07-19 23:14:43.56 spid28s Started listening on virtual network name 'MSSQLSERVER'. No user action is required. 2024-07-19 23:14:43.56 spid28s The Database Mirroring endpoint is now listening for connections. 2024-07-19 23:14:43.71 spid28s Service Broker manager has started. 2024-07-19 23:14:43.72 spid4s Recovery is complete. This is an informational message only. No user action is required. 2024-07-19 23:14:43.82 spid51 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 2024-07-19 23:14:43.83 spid51 Using 'xpstar.dll' version '2015.130.1601' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2024-07-19 23:14:47.32 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:14:47.32 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:14:52.33 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:14:52.33 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:14:57.35 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:14:57.35 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:02.37 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:02.37 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:07.39 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:07.39 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:12.41 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:12.41 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:15.73 spid62 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required. 2024-07-19 23:15:15.73 spid62 Using 'xpsqlbot.dll' version '2015.130.1601' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required. 2024-07-19 23:15:17.42 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:17.42 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:22.44 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:22.44 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:15:27.46 Logon 错误: 18470，严重性: 14，状态: 1。 2024-07-19 23:15:27.46 Logon Login failed for user 'SJ\SJ02$'. Reason: The account is disabled. [客户端: 192.168.3.182] 2024-07-19 23:17:31.94 spid21s Error: 41065, Severity: 16, State: 0. 2024-07-19 23:17:31.94 spid21s Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID: 'c7bc648e-8d1c-43fa-911d-9379059cea14') online at this time. The WSFC resource is not in a state that can accept the request. Wait for the WSFC resource to enter a terminal state, and retry the operation. For information about this error, see error code 5023 in "System Error Codes" in the Windows Development documentation. 2024-07-19 23:17:31.94 spid21s Error: 41160, Severity: 16, State: 0. 2024-07-19 23:17:31.94 spid21s Failed to designate the local availability replica of availability group 'ag-ipmsprod' as the primary replica. The operation encountered SQL Server error 41065 and has been terminated. Check the preceding error and the SQL Server error log for more details about the error and corrective actions.
从日志上看，数据库是能正常启动的，但是在群集管理上看 SQL Server 服务一直处于联机挂起状态。联机挂起期间可正常登录数据库，但是短时间后数据库又会重启（故障转移群集不断联机尝试，直到失败阈值）。
Solution:
故障转移集群 WSFC 通过 NT AUTHORITY\SYSTEM 用户登录数据库并检查数据库状态，该用户不存在或权限丢失将导致群集无法正常识别数据库状态。
登录 SSMS，查看用户 NT AUTHORITY\SYSTEM 是否存在及权限是否正确，可用以下命令创建该用户并授权：
use [master] GO CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[简体中文] GO GRANTVIEW SERVER STATE TO [NT AUTHORITY\SYSTEM] AS [sa] GO
The SQL Server service online failed
Analysis Services 和 SQL Server 服务失败。
2024-07-25 16:48:04.24 Server Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)
2024-07-25 16:48:04.27 Server UTC adjustment: 8:00 2024-07-25 16:48:04.27 Server (c) Microsoft Corporation. 2024-07-25 16:48:04.28 Server All rights reserved. 2024-07-25 16:48:04.28 Server Server process ID is 5928. 2024-07-25 16:48:04.29 Server System Manufacturer: 'VMware, Inc.', System Model: 'VMware7,1'. 2024-07-25 16:48:04.29 Server Authentication mode is MIXED. 2024-07-25 16:48:04.29 Server Logging SQL Server messages in file 'F:\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2024-07-25 16:48:04.29 Server The service account is 'SJ\administrator'. This is an informational message; no user action is required. 2024-07-25 16:48:04.30 Server Registry startup parameters: -d F:\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf -e F:\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG -l F:\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2024-07-25 16:48:04.30 Server Command Line Startup Parameters: -s "MSSQLSERVER" 2024-07-25 16:48:04.39 Server SQL Server detected 2 sockets with 2 cores per socket and 2 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. 2024-07-25 16:48:04.39 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2024-07-25 16:48:04.40 Server Detected 8191 MB of RAM. This is an informational message; no user action is required. 2024-07-25 16:48:04.40 Server Using conventional memory in the memory manager. 2024-07-25 16:48:05.82 Server Default collation: Chinese_PRC_CI_AS (简体中文 2052) 2024-07-25 16:48:07.40 Server Buffer pool extension is already disabled. No action is necessary. 2024-07-25 16:48:09.62 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled. 2024-07-25 16:48:09.62 Server Implied authentication manager initialization failed. Implied authentication will be disabled. 2024-07-25 16:48:11.33 Server The maximum number of dedicated administrator connections for this instance is '1' 2024-07-25 16:48:11.39 Server This instance of SQL Server last reported using a process ID of 8452 at 2024/7/25 11:36:18 (local) 2024/7/25 3:36:18 (UTC). This is an informational message only; no user action is required. 2024-07-25 16:48:11.54 Server 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. 2024-07-25 16:48:11.72 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. 2024-07-25 16:48:11.84 Server Database Instant File Initialization: 已启用. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required. 2024-07-25 16:48:12.04 Server Query Store settings initialized with enabled = 1, 2024-07-25 16:48:12.46 spid5s Starting up database 'master'. 2024-07-25 16:48:13.39 Server CLR version v4.0.30319 loaded. 2024-07-25 16:48:13.96 Server Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\. 2024-07-25 16:48:14.97 Server Software Usage Metrics is enabled. 2024-07-25 16:48:15.09 spid5s Resource governor reconfiguration succeeded. 2024-07-25 16:48:15.10 spid5s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2024-07-25 16:48:15.13 spid5s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2024-07-25 16:48:16.49 spid5s SQL Trace ID 1 was started by login "sa". 2024-07-25 16:48:16.55 spid5s Server name is 'MSSQLSERVER'. This is an informational message only. No user action is required. 2024-07-25 16:48:16.55 spid5s The NETBIOS name of the local node that is running the server is 'SJ01'. This is an informational message only. No user action is required. 2024-07-25 16:48:16.97 spid15s A self-generated certificate was successfully loaded for encryption. 2024-07-25 16:48:17.00 spid15s Server is listening on [ 192.168.3.185 </i><ipv4> 1433]. 2024-07-25 16:48:17.00 spid15s Started listening on virtual network name 'MSSQLSERVER'. No user action is required. 2024-07-25 16:48:17.00 spid15s Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2024-07-25 16:48:17.00 spid15s Server named pipe provider is ready to accept connection on [ \\.\pipe\$$\MSSQLSERVER\sql\query ]. 2024-07-25 16:48:17.01 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required. 2024-07-25 16:48:17.01 Server 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. 2024-07-25 16:48:17.12 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com ] for the SQL Server service. 2024-07-25 16:48:17.14 Server The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com:1433 ] for the SQL Server service. 2024-07-25 16:48:17.95 spid17s A new instance of the full-text filter daemon host process has been successfully started. 2024-07-25 16:48:18.17 spid5s Database mirroring has been enabled on this instance of SQL Server. 2024-07-25 16:48:18.17 spid20s Always On: The availability replica manager is starting. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid23s Starting up database 'DWDiagnostics'. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid6s Starting up database 'mssqlsystemresource'. 2024-07-25 16:48:18.17 spid25s Starting up database 'DWConfiguration'. 2024-07-25 16:48:18.17 spid22s Starting up database 'msdb'. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to start. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid27s Starting up database 'ipmsprod'. 2024-07-25 16:48:18.17 spid26s Starting up database 'DWQueue'. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Local Windows Server Failover Clustering node started. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Waiting for local Windows Server Failover Clustering node to come online. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid20s Always On Availability Groups: Local Windows Server Failover Clustering node is online. This is an informational message only. No user action is required. 2024-07-25 16:48:18.17 spid20s Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required. 2024-07-25 16:48:18.24 spid6s The resource database build version is 13.00.4001. This is an informational message only. No user action is required. 2024-07-25 16:48:18.54 spid6s Starting up database 'model'. 2024-07-25 16:48:20.23 spid6s Polybase feature initialization successful, hadoop connectivity 0x7, node role: 0x1. 2024-07-25 16:48:20.23 spid6s Clearing tempdb database. 2024-07-25 16:48:23.60 spid6s Starting up database 'tempdb'. 2024-07-25 16:48:26.32 spid6s The tempdb database has 4 data file(s). 2024-07-25 16:48:26.38 spid6s TEMPDB configuration for Polybase completed successfully. 2024-07-25 16:48:26.38 spid20s The Service Broker endpoint is in disabled or stopped state. 2024-07-25 16:48:26.41 spid20s Server is listening on [ 192.168.3.185 </i><ipv4> 5022]. 2024-07-25 16:48:26.41 spid20s Started listening on virtual network name 'MSSQLSERVER'. No user action is required. 2024-07-25 16:48:26.41 spid20s The Database Mirroring endpoint is now listening for connections. 2024-07-25 16:48:26.80 spid20s Service Broker manager has started. 2024-07-25 16:48:26.81 spid5s Recovery is complete. This is an informational message only. No user action is required. 2024-07-25 16:48:27.29 spid52 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. 2024-07-25 16:48:27.55 spid52 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. 2024-07-25 16:48:27.84 spid52 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. 2024-07-25 16:48:28.70 spid52 Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required. 2024-07-25 16:48:28.71 spid52 Using 'xpsqlbot.dll' version '2015.130.1601' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required. 2024-07-25 16:48:28.84 spid52 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 2024-07-25 16:48:28.90 spid52 Using 'xpstar.dll' version '2015.130.1601' to execute extended stored procedure 'xp_sqlagent_notify'. This is an informational message only; no user action is required. 2024-07-25 16:48:52.99 spid103 Attempting to load library C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Polybase\SharedMemory.dll 2024-07-25 16:48:53.02 spid103 Shared memory segment initialized with name Global\4d5c9fbf9e1947c188003a47aa31c811 2024-07-25 16:53:04.67 spid52 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. 2024-07-25 16:53:04.70 spid52 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. 2024-07-25 16:53:04.73 spid52 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. 2024-07-25 16:53:04.95 spid5s Always On: The availability replica manager is going offline because SQL Server is shutting down. This is an informational message only. No user action is required. 2024-07-25 16:53:04.95 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. 2024-07-25 16:53:05.63 spid20s The Database Mirroring endpoint has stopped listening for connections. 2024-07-25 16:53:05.63 spid20s Service Broker manager has shut down. 2024-07-25 16:53:12.39 spid5s .NET Framework runtime has been stopped. 2024-07-25 16:53:13.15 spid5s SQL Server shutdown has been initiated 2024-07-25 16:53:13.15 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. 2024-07-25 16:53:13.28 spid15s The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com ] for the SQL Server service. 2024-07-25 16:53:13.28 spid15s The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/MSSQLSERVER.sj.com:1433 ] for the SQL Server service.
