SSRS report dies with error

Hi Chris,

Good day.

I think you can use SSRS URL format first. make sure reporting service report is working, then you can setup the proxy.

For SSRS URL, you only need to config T_DEFAULTS: SSRS_URL field.

Is your report working in IE?

have fun.

Ben

Unknown said:

I think you can use SSRS URL format first. make sure reporting service report is working, then you can setup the proxy.

For SSRS URL, you only need to config T_DEFAULTS: SSRS_URL field.

Is your report working in IE?

Yes, the SSRS_URL variable is set to "http://actedata/Reports", which, if I open in IE, opens Report Manager. I can click through the folder structure and open my new report, and it generates fine.

Today I seem to be getting closer. When I try to run the report from Tessitura, I get this error:

Next, I see this in event viewer:

"It is not possible to run two different versions of ASP.NET in the same IIS process. Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process."

In IIS, TessituraSSRSProxy is running under ASP.NET 1.1.4322, which is grayed out and can't be changed. Is your Proxy running under that version? Any other suggestions?

Thanks!

Unknown said:

The URL in SSRS_URL (T_DEFAULTS) needs to be the Report Server (http://server/ReportServer), not the Report Manager (http://server/Reports).

Thanks for your reply. I've made that update to t_defaults, logged my client in/out, and am still getting the "Server application unavailable" message pictured above.

If I just try to load the SSRS_URL in a browser, I get this. Is this what I should see?

Unknown said:

That might mean that the ReportServer is not configured on the web server (IIS) as an application, or the permissions aren’t set appropriately on the web server or the virtual directory to be able to execute scripts.

 

In IIS, I see that ReportServer appears under Application Pools and Web Sites -> Default Web Site. Under the latter, I see entries for both Reports and Report Server. Both seem to be set up as Applications. Reports had already been set up to allow execution of Scripts & Executables, though Report Server had not. I added that setting to ReportServer, clicked Apply, and tried running the report again. Same result. Does the reporting services service (or something else) need to be restarted?

Thanks.

Hi Chris,

Good day.

To make reporting service work,

1, normally start from sql server 2005-->configuration tools-->reporting service configuration (this should be done from sql reporting service instance machine<actedata>, you need the admin login to do this)

2,after you setup this admin account, you need to go back IE, type in http://localhost/reports (I assume you use the default website), in the report manger, choose the "Site Settings", add some new users, especially yourself, then you do not need admin account any more. You can add yourself as "System All".  (this part still need to be done at instance machine)

3,then you can go to the report folder to setup individaul report security. add persons and groups with permissions.(this part can be done at domain machines)

you can play with all those steps, it will take a bit time then you will know the whole thing.

For the reporting service, there are two parts.

1, part 1 is report manager, this part controls the security configuration. the link is something like http://reportingServiceMachine/reports

2, part 2 is for report usage, this part have an interface like FTP, when you try to consume the reports, you have to go through this part. http://reportingServiceMachine/reportserver

after you make all things working, you can take a look of this, it is about dropdown list selection:

http://www.tessituranetwork.com/COMMUNITY/forums/p/315/1707.aspx#1707

have fun

Ben