Compartir a través de

Reporting Services Server Properties Grayed Out

  • Artículo

In doing some research and testing for one of my screen casts on SRS and Config Manager I ran into an issue that I couldn’t find much information on.  

My SQL Server is running SQL 2005 SP3 with CU 1 and is on a different box than the Config Manager site server.  I also run on a named instance of SQL.

I was at the point of configuring the properties of the SRS Server in the Config Manager Console when I got the screen below:

image

Everything was grayed out on all tabs.  I also saw this in the SRSRP.log file:

Failures reported during periodic health check by the SRS Server STRAWBERRY. Will retry check in 57 minutes    SMS_SRS_REPORTING_POINT    2/17/2009 8:13:14 PM    2388 (0x0954)

I found in the Event Log this event ID:

image 

For some unknown reason when I did the install of SRS the Network Service account was not granted permissions to the Temp ASP.Net folder.  Not only did this cause the SRSRP Service to have issues but this affected the Config Manager Console to allow me to configure the properties of the SRS Server.

I went into the properties of the Temp ASP.Net folder and added the Network Service account and granted him full control permissions.  I then restarted the SRSRP service and the log then cleared up.  I went back to the Config Manager box and selected properties of the SRS server and now the tabs were allowing me to enter data.

Comments

  • Anonymous
    June 02, 2009
    Where do I find the "I went into the properties of the Temp ASP.Net folder and added the Network Service account"? Thanks

  • Anonymous
    October 27, 2009
    in answer the to the question above, navigate to the directory specified in the error, right click -> properties -> security -> add network service with full control.

  • Anonymous
    March 29, 2010
    The comment has been removed

  • Anonymous
    May 20, 2011
    The comment has been removed

  • Anonymous
    January 21, 2014
    hahhaha