SSRS Error Managing reports
We are using Server 2012 with SQL Server 2008R2. When I try to manage a report in SSRS, I get this error : operation is not valid due to the current state of the object. In looking for solutions I found this "On our systems, I found it to be related to KB2656355 (Server 2008 R2)"
We do not have this as we are on SQL 2012. I also found "You can override the value by adding the following key to the appsetttings section in your SSRS report manager web.config file (usually in Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\
<add key="aspnet:MaxHttpCollect
The reports all run properly but I cannot manage them. Any suggestion?
We do not have this as we are on SQL 2012. I also found "You can override the value by adding the following key to the appsetttings section in your SSRS report manager web.config file (usually in Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\
<add key="aspnet:MaxHttpCollect
The reports all run properly but I cannot manage them. Any suggestion?
ASKER
No IIS sites ware using the same....
The reporting services runs as Network Service
The reporting services runs as Network Service
To get this working in my setup I had to make a user (I called it reportmgr) and added it to all the ssrs and SQL groups I could find. Then I ran ssrs as this user.
Here is an article that addresses a few issues but I went through many getting mine working
http://skamie.wordpress.com/2010/06/24/ssrs-and-uac/
Here is an article that addresses a few issues but I went through many getting mine working
http://skamie.wordpress.com/2010/06/24/ssrs-and-uac/
ASKER
I tried all of that and still didn't work. The odd thing is that I can hit manage on the linked reports but not the report that starts the link. Also the reports run fine. I just cannot change their parameter defaults or their data source. I keep thinking that it is a windows update causing the problem with 2012 as it is with 2008R2 but I don't know which ones
so whats different in the link from when you hit manage vs the report? does one have localhost and one has the real domain name?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Put in a ticket with Microsoft
What user does the reporting service run as?