Category Archives: Reporting Services

Info: SSRS in SharePoint Integration Mode vs Native Mode


SQL Reporting Services in SharePoint Integration Mode

When you integrate a report server with an instance of a SharePoint product, items and properties are stored in the SharePoint content databases. This provides a deeper level of integration between the server technologies that effects how content is stored, secured, and accessed.

Storing report items and properties in SharePoint content databases allows you to browse SharePoint libraries for report server content types, secure items using the same permission levels and authentication provider that controls access to other business documents hosted on a SharePoint site, use the collaboration and document management features to check reports in and out for modification, use alerts to find out if an item has changed, and embed or customize the Report Viewer Web part on pages and sites within the application. If you have sufficient permissions within a SharePoint site, you can also generate report models from shared data sources and use Report Builder to create reports.

The report server continues to provide all data processing, rendering, and delivery. It also supports all scheduled report processing for snapshots and report history. The following diagram shows the server components together:

architecture diagram

SQL Reporting Services in Native Mode

Reports are being hosted in a separate server as Native Mode and developers are adding the reports URL in to the SharePoint Pages. When we open a report by clicking the link in SharePoint page, SharePoint redirected to the Report Server URL. Thus, report server is running as an isolated server from the SharePoint.

Leave a comment

Posted by on February 24, 2012 in Reporting Services, Sharepoint


Reporting Services Issue on MOSS 2007 Extranet Deployment

Scenario:As shown in following figure, we have deployed two WFEs on least trusted domain (e.g., ABC domain) and central admin, database servers, and reporting services(i.e., Reporting Services running on SharePoint Integration Mode) are in Highly Trusted Domain (e.g., XYZ Domain).

Reporting Services on Extranet MOSS 2007 Environment

Moreever there is an one-way trust between Extranet Domain and Intranet Domain. When users are trying to access or upload the rdl files to SharePoint environment, users are experiencing logon challenges (i.e., Double-Hop problem)

We were tried to engage MSFT customer support and they were said that we need to have a two-way trust between extranet domain and intranet domain. That is not make sense to our corporate architecture team. Then finally MSFT support asked us to move database+reporting services server and central adminstration server to least trusted domain (i.e., Extranet Domain) – this is obviously worst suggestion by MSFT support since we can not expose database and central administration servers to extranet. Finally, we dig into the issue and resolved the issue by adding the IP address of WFEs in host entry of each WFEs.

If you are experencing same issues as described above, please add the IP address of WFEs into host entries of each WFEs.

Hope this helps!


Posted by on February 9, 2010 in Reporting Services, Sharepoint