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 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 act...
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...
Read more

SharePoint 2013 Features

Image
http://msdn.microsoft.com/en-us/library/jj163091(v=office.15).aspx This page contains a huge amount of information on various different dev related topics. My personal highlights are Cloud App Model REST endpoints New client and server APIs Remote Event Receivers Workflow 4.0 Managed Navigation Cross-Site Publishing EDiscovery and many more Office 365 also availabe with free version.
Read more