Error occurred while opening logfile C:\Windows\system32\LogFiles\Sum\Api.log

15

I need to restart the MS SQL server service every morning because my web client site can not connect.
However, when I start my services it works. I don't know what is causing 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 somebody can help me fix this.

sql-server
visual-studio-2012
window
asked on Stack Overflow Sep 14, 2014 by Jonathan Sameniego • edited Sep 14, 2014 by Jonathan Sameniego

1 Answer

22

Your serviceaccount need access to the folder:

C:\Windows\System32\LogFiles\Sum

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

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

answered on Stack Overflow Sep 16, 2014 by Bjørn Christopher Wang • edited Sep 16, 2014 by Soner Gönül

User contributions licensed under CC BY-SA 3.0