SQL Reporting Services Cannot Access rsReportServer.config File

SQL Server 2005 Box

SQL Server 2005 Box

I ran into this issue the other day and I thought I would share the simple answer that I found with you.

After installing SQL Reporting Services on a Windows Server 2008 Machine I attempted to verify successful installation by browsing to http://localhost/ReportServer. I was greeted by this message: “Access to the path ‘C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config’ is denied”.

 After verifying that the SQL instance in question was running under the Network Service account I navigated to the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer directory, and opened up the security properties of the rsReportServer.config file. I noticed Network Service was not listed. I explicitly granted Network Service access to the rsReportServer.config file, restarted IIS, and it started working!

 As a side note, I when reporting services are installed several groups are created locally (or in AD if you are doing it on a DC). If your computer name is longer than 6 characters it cannot create the proper group name (it is too long) and it just shows the SID in AD Users and Computers. Odd huh?

This entry was posted in Software and tagged , . Bookmark the permalink.

7 Responses to SQL Reporting Services Cannot Access rsReportServer.config File

  1. Funky One says:

    Thanks for the solution. Saved us a lot of time!

  2. Wayne says:

    My understanding is that a blue laser, being on the other end of the color spectrum from the standard red, can hold more information. Granted the difference in light only accomodates a minor increase in the number of bits that can be read. But over the entire read cycle it adds up. Also, and not sure about this, but the blue spectrum may also provide for a tighter radial pattern on the disc as well. Not sure, like I said.

    Nice blog, looks pretty clean! Cheers!

  3. Nero says:

    Richard you are great.

  4. yoj says:

    This was helpful! Thanks so much!

  5. Ahmed Afify says:

    Thank you very much …

  6. Johnny says:

    Your information has really proven to be helpful.

  7. Richard says:

    @Johnny Glad to hear it! =]

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">