今天我在嘗試從重新開機啟動 SQL Server 時遇到一點意外。伺服器在重新開機前是正常運作的,所以我有種不祥的預感,這個問題可能不太容易。我做的第一件事是檢查 SQL Server 記錄看看發生了什麼事。2014-08-23 02:09:44.63 Server Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)2014-08-23 02:09:44.63 Server (c) Microsoft Corporation.2014-08-23 02:09:44.63 Server All rights reserved.2014-08-23 02:09:44.63 Server Server process ID is 3704.2014-08-23 02:09:44.63 Server System Manufacturer: ‘VMware, Inc.’, System Model: ‘VMware Virtual Platform’.2014-08-23 02:09:44.63 Server Authentication mode is WINDOWS-ONLY.2014-08-23 02:09:44.63 Server Logging SQL Server messages in file ‘E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLLogERRORLOG’.2014-08-23 02:09:44.63 Server The service account is ‘DOMAINdatabaseservice’. This is an informational message; no user action is required.2014-08-23 02:09:44.63 Server Registry startup parameters: -d E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAmaster.mdf -e E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLLogERRORLOG -l E:Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQLDATAmastlog.ldf -T 8295 -T 41992014-08-23 02:09:44.63 Server Command Line Startup Parameters: -s “MSSQLSERVER"2014-08-23 02:09:44.77 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical
啟動 SQL Server 的問題:無法初始化 SSL 支援
作者 Kevin Kaminski
訂閱 Big Hat 簡報
每兩週一期,解讀 AI、Azure 與現代開發——由親手打造這些系統的顧問撰寫,而非行銷團隊。