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.
Where do I find the "I went into the properties of the Temp ASP.Net folder and added the Network Service account"?
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.
I'm experiencing a similar problem, different Event log errors, I'll post them below.
Question - Is the Network Service account being referenced above, the same as the SCCM client "Network Access Account"?
Here are my Event log errors:
SMS Server error:
On 3/29/2010 3:26:21 PM, component SMS_SRS_REPORTING_POINT on computer UCCQASCCM reported: SMS SRS web service is not running on SRS Reporting point server "UCCQASCCM".
ASP.NET 2.0.50727.0 Error:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/29/2010 1:27:50 PM
Event time (UTC): 3/29/2010 8:27:50 PM
Event ID: 2978da38cc8e448990fa454690f91d0a
Event sequence: 3
Event occurrence: 1
Event detail code: 0
Application domain: /LM/W3SVC/1/ROOT/ReportServer-1-129143675794638445
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
Machine name: UCCQASCCM
Process ID: 4140
Process name: w3wp.exe
Account name: IIS APPPOOL\DefaultAppPool
Exception type: ServerConfigurationErrorException
Exception message: The report server has encountered a configuration error. See the report server log files for more information.
User host address:
Is authenticated: False
Thread account name: IIS APPPOOL\DefaultAppPool
Thread ID: 6
Is impersonating: False
Stack trace: at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
Custom event details:
u wanna free sex? jz mail me at email@example.com