Unable to start SQLServer service via VCS Java Console GUI
Article ID: 100052621
Updated On:
Description
Error Message
1.VCS ERROR V-16-20093-11 SQLServer:SQLServer-MSSQLSERVER:online:Failed to wait for the service 'MSSQLSERVER' to start. Error = [6 ,1]
2.The SQLServer MSSQLSERVER service also fails to start via Windows Service Control Manager (SCM.)
Error 1067: The Process Terminated Unexpectedly
3.Event ID 17058 in Windows application event log: initerrlog: Could not open error log file 'S:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(Access is denied.).
Cause
Incorrect log on account for MSSQLSERVER service
Resolution
By default the "Log On" account for MSSQLSERVER is 'NT Service\MSSQLSERVER' while install SQL Server 2016. This account may not use the same SID between cluster nodes and would require a common context for proper failover between cluster nodes. Change the log on account to the proper account after SQL is configured into VCS, such as the Local System account or Domain\user.
Issue/Introduction
