Server Error: 17058, Severity: 16, State: 1.
Error:
Server initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 5(Access is denied.).
Issue: Created a new user and restarted service with the new user.
It started giving the error mentioned above.
Solution: Moved the file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG" to a different location and the service started.
Hurray!!
Hope it helps :)
NOTE: Ideally on Sql Server restart a new error file is created.
If existing file is named as "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG"
New file will be named as "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG.1"
Need to dig more.. right?
Wednesday#90210
No comments:
Post a Comment