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:
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:
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.