[Windows Server 2008]解決 SQL主機變更為網域控制器(Domain Controller)後,啟動SQL Server出現:initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

問題

---

SQL主機變更為網域控制器(Domain Controller)後,啟動SQL Server出現:initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

背景:
當將一台原安裝SQL Server 2k8的主機,拿來當網域控制器(Domain Controller)後,發現SQL Server無法開啟,並且在事件檢視器(Event Viewer)出現錯誤訊息:
initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).


解決方法

---

發生原因:
由於主機變更為網域控制器(Domain Controller),在主機上的權限要變更為網域控制器裡有Administrator權限的使用者才有權限開啟於主機上的服務
解決方式:
進服務(Service)選擇SQL Server (MSSQLSERVER)服務,右鍵=>屬性=>Log On 標籤=>指定由網域控制器的Administrator權限開啟

啟用狀況