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\’.
REASON :
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.
SOLUTION :
Next add the new Domain AD Account to grant access to the Reporting Folders.