SSRS Multiple Reports Problem
Hello Experts,
I have multiple SSAS databases on a single server. My SSRS projects are located in the same server. Both of these two projects' TargetServerURL property has been set as :
http://localhost/TESTSERVER/REPORTS_CENTER
These separate SSRS projects connect to their own seperate SSAS databases. But my clients cannot connect either one of these SSRS reports.
For example if I deploy project1 (the first SSRS project) then the other project cannot be seen by my network clients. If I deploy the second project then the first project cannot be seen.
How can I run both of these projects on a single server?
Any idea?
May 3rd, 2011 10:55am
Hi innocent1973,
Based on my experience, the issue could be related to data source settings in each project. And I would suggest you check the OverwriteDataSources option, the TargetDataSourceFolder item and the TargetReportFolder item first. Please make sure that the
two project has different DataSourceFolder name and ReportFolder name.
Moreover, if you can provide detailed symptom information regarding the problem, we may have more concrete ideas.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2011 8:52am
Hi innocent1973,
Based on my experience, the issue could be related to data source settings in each project. And I would suggest you check the OverwriteDataSources option, the TargetDataSourceFolder item and the TargetReportFolder item first. Please make sure that the
two project has different DataSourceFolder name and ReportFolder name.
Moreover, if you can provide detailed symptom information regarding the problem, we may have more concrete ideas.
Thanks,
Eileen
May 8th, 2011 8:52am