MS SQL SSRS – HTTP Error 500

April 15, 2016

Recently we got an MS SQL SSRS – HTTP Error 500.

image

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.

image

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.

clip_image002

SOLUTION :

clip_image004

Next add the new Domain AD Account to grant access to the Reporting Folders.

image


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

April 14, 2016

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

image

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

Solution :

1. Open the command prompt in elevated mode.

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

Dir /x

image

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

image

4. Now you can delete the file or folder.

Enjoy!