Error opening log file C: \ Windows \ system32 \ LogFiles \ Sum \ Api.log

Question

I need to restart the MS SQL server service every morning because my web client site cannot connect.
However, when I start my services, it works. I do not know what causes the problem. I found this in my error log.

sqlservr (4052) An attempt to open the file "C:\Windows\system32\LogFiles\Sum\Api.log" for read only access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8). sqlservr (3000) An attempt to open the file "C:\Windows\system32\LogFiles\Sum\Api.chk" for read / write access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8). 

Hope someone can help me fix this.

Answer 1

Your service account must have access to the folder:

 C:\Windows\System32\LogFiles\Sum 

Go to the folder and add an account with read / write permissions.

http://support.microsoft.com/kb/2811566