Recently we got an MS SQL SSRS – HTTP Error 500.
The Reporting services was working just fine the day before?
EventViewer ID’s. you see the message that there is a security issue on the RSTempFiles folder.
Message: The current identity (NT AUTHORITY\LOCAL SERVICE) does not have write access to ‘C:\Program Files\Microsoft SQL Server\MSRS10_50.SIGMA\Reporting Services\RSTempFiles\’.
The main reason is that before the SSRS server was a local server in the Domain.
Afterwards we promote the server to a Domain Controller.
As you can see on the RSTempFiles folder Security, you see that the local account SYSTEM account has become obsolete.
Next add the new Domain AD Account to grant access to the Reporting Folders.