Reporting Services Server Properties Grayed Out

Reporting Services Server Properties Grayed Out

  • Comments 5
  • Likes

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
  • Where do I find the "I went into the properties of the Temp ASP.Net folder and added the Network Service account"?

    Thanks

  • 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 information:

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

       Process ID: 4140

       Process name: w3wp.exe

       Account name: IIS APPPOOL\DefaultAppPool

    Exception information:

       Exception type: ServerConfigurationErrorException

       Exception message: The report server has encountered a configuration error. See the report server log files for more information.

    Request information:

       Request URL:  

       Request path:  

       User host address:  

       User:  

       Is authenticated: False

       Authentication Type:  

       Thread account name: IIS APPPOOL\DefaultAppPool

    Thread information:

       Thread ID: 6

       Thread account name: IIS APPPOOL\DefaultAppPool

       Is impersonating: False

       Stack trace:    at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()

      at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()

    Custom event details:

  • u wanna free sex? jz mail me at kritti_kanblue@yahoo.com

  • hahhaha

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment