SQL Server Reporting Service Configuration



SSRS Configuration
SQL server reporting services can be configured in two modes
§  Native mode
§  SharePoint Integration mode
When reporting services are running in native mode, the reports will store on SQL server reporting server. When user sends a request for report the response comes from Report Server in SQL Server.
When reporting services running in SharePoint integration mode, SharePoint gets the reports from server via web service to end users.
Installation Instructions
SQL Server 2008 R2 Installation instructions to enable reporting services in SharePoint integration mode.
1. Select the SQL Server Feature Installation option from SQL Server 2008 R2 setup page
2. On the features selection page, Select Database Engine Services, Reporting Services then click Next
3. In Server Configuration page enter appropriate credentials and click Next
Note: SharePoint 2010 products in farm configuration require domain accounts     for service configurations.
4. On Reporting Services Configuration page, select Install SharePoint integrated mode default configuration and say finish.
Configuration steps on Report Server
After Setup is finished, you can verify that installation by connecting to the report server. You can test by browsing to /reportserver">http:///reportserver
1. Open the Reporting Services Configuration Manager from Configuration tools

2. Select the report server instance that you installed in SharePoint Integration mode\

3. Configure the web service URL and test whether it is running fine or not. We are going to use this url in SharePoint Administration tool

4. Make sure your database is using SharePoint Integration Mode

Configuration Steps on SharePoint Server
1. Open the SharePoint Central Administration toll and the click General Application Settings

2. Click on Reporting Services Integration link under Reporting Services. 
Enter the Reporting server web services URL that you configured earlier in the  Web Services URL box. Enter the authentication mode that you are using and credentials in the respective box then click ok

3. Upload the rdl files (SQL report files) to document library in SharePoint. If the configuration is successful then you should be able to see the SQL server Report in SharePoint 2010 as follows


Comments

Post a Comment

Popular posts from this blog

SharePoint: Group By on more than 2 columns in a view (SP 2010)

Image
An expanded version of this article, along with many other customization examples and how-tos can be found in my book,  SharePoint 2007 and 2010 Customization for the Site Owner . This is an update of an  article written for SharePoint 2007 . Many of the steps are the same in both 2007 and 2010, but both the SharePoint Designer steps and the default web part used for views have changed. Group By on more than 2 columns in a view In my SharePoint classes I have often been of asked how to group on more than two levels in a view. I have always given the quick answer of "use SharePoint Designer"!  But, some of you have asked "How?". You may be sorry you asked… but here goes…  Goals:  Create a view with nested groups deeper than just 2 levels Put the counts and totals at the bottom of each section. Do the above with no custom web parts, custom XSLT or anything that has to be deployed to the server. Sample:       Secrets and Tricks needed:  It can't be done &
Read more

Configure Form Based Authentication (FBA) in SharePoint 2010

Image
Steps to Configure FBA in SharePoint 2010  Below are the steps required to configure FBA in SharePoint 2010. I will be using MS SQL database as membership store for users.   A) Setting up ASP.NET Forms Authentication User and Role Data Source  1. Create Database  2. Configure Membership and Role Provider  3. Create User B) Create Web Application and Site Collections C) Configure Web.Config file  1. Configuring FBA web application web.config file 2. Configuring Central Administration web application web.config file 3. Configuring Security Token Service web.config file D) Adding User Policy to the FBA Web Application E) Verification Steps  A) Setting up ASP.NET Forms Authentication User and Role Data Source  This section explains creation of database which is used to store user's information such as credentials and roles which is used for Form Authentication. This section also explains the configuration of Membership and Role providers in the web.
Read more

SharePoint 2010 Windows PowerShell Interview Questions

Q. What is Windows Powershell ? Ans.  Windows PowerShell is a new Windows command-line shell designed especially for system administrators. In the SharePoint administration context, Windows PowerShell is another administration tool that supersedes the existing Stsadm.exe. Q. How is Windows Powershell different from Stsadm ? Ans.  Unlike stsadm, which accept and return text, Windows PowerShell is built on the Microsoft .NET Framework and accepts and returns .NET Framework objects. In addition to that it also gives you access to the file system on the computer so that you can access registry,digital signature certificate etc.. Q. What are cmdlet's? Ans.  Windows PowerShell introduces the concept of a cmdlet which are simple build in commands, written in a .net language like C# or VB. Q. Can you Create PowerShell scripts for deploying components in SharePoint ? Ans . If you are creating a webpart with VS 2010 then you can deploy it using ctrl + f5. However, to activate the
Read more