MS SQL – SSRS HTTP Error 500

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.

Windows – The requested security information is either unavailable or can’t be displayed.

At some point a file or folder might give you this error, when trying to view the Security Properties.

The result is that you can’t delete the respective file or folder

Solution :

1. Open the command prompt in elevated mode.

2. Go to the Parent folder, next use this command.

Dir /x

You will see the 8.3 short name of the file or folder.

3. Next you can rename the file or folder using this command, using the short name reference

Rename xxxx yyyyy

4. Now you can delete the file or folder.

Enjoy!