Hello, this is how I solved the above issue.
Issue
The SQL server cannot write to the errorlog file in the log folder. The file is either set to readonly or permission issue.
Sometimes, you can verify all the permissions on the Log folder, and they may seem ok but you can still not start the MSSQLSERVER service. Do not worry.
Solution
- cd to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log"
- Look for "ERRORLOG" in the log folder
- Delete or rename ERRORLOG
- Start MSSQLSERVER services again or restart the server.
- You are done. Good Luck