Setup SSRs in SharePoint integrated mode

Setup SSRs in SharePoint integrated mode

This post is about processing ing SQL Server reporting services in SharePoint integrated mode the quick and clean way with no fuzz in 40 steps.

I'm not discussing the default values, I will
Only talk about the values which need to be changed or selected in order
To get SSRs set up in the least amount of steps.

The scenario:

• SharePoint 2010 Enterprise Edition + named instance SQL Server 2008
  Express edition which is deployed during the SharePoint setup. Name
  The SQL Server instance: Sharepoint.
• Separate default SQL Server 2008 R2 instance (Enterprise Edition ).
• SSRs currently installed in native mode on the SQL Server 2008 R2 default instance.
• Adventureworksdw2008r2 hosted on the SQL Server 2008 R2 default instance.

The procedure contains 5 parts:

A. SSRs configuration {SQL Server} B. web application {SharePoint} C. site collection {SharePoint} D. SSRs integration {SharePoint} e. content types {SharePoint} Let's start!   A. SSRs configuration {SQL Server}

2. Log on to your SharePoint 2010 box.
4. Fire upSQL Server Reporting Services Configuration Manager.
6. Connect toReport Server instance. In my case this is the default SQL Server 2008 R2 instance (MSSQLServer)
8. The first thing you will notice isReport Server Status. CheckReport Server Mode. It shoshould sayNative(We start from native mode in this scenario ).
10. ClickDatabaseIn the left pane. ClickChange Database. SelectCreate a New Report Server Database.
    Enter the proper credentials.
12. EnterDatabase NameAnd selectSharePoint integrated mode.
14. EnterCredentialsAnd do not forget the <domain name >\< username> (. \ <username> will do as well ).
16. ChooseReport manager URLIn the left pane and clickApplyButton. This will configure the report manager virtual directory.
18. BackupEncryption Keys.

  B. Web application {SharePoint}

2. OpenSharePoint Central AdministrationWebsite.
4. ChooseApplication Management> Manage web applications.
6. ClickNewButton in the ribbon. This will bring upCreate new Web ApplicationPopup.
8. Keep the default values to keep things simple syntax t:
   1. ChooseNameFor the newIIS website. I will choose ssrsdemo in this example.
   2. ChooseNameForApplication pool. I will again choose ssrsdemo.
   3. Make sure you connect to the right database instance. In my example I
      Will connect to the named SQL Server 2008 express edition instance
      Named Sharepoint.
   4. ChooseDatabase NameOr keep the default value with the guid suffix. I will call the database wss_content_ssrsdemo.
   5. Hold your horses before you hit the OK button when this information pops up:

The Microsoft SharePoint Foundation web application has been created.

If
This is the first time that you have used this application pool with
SharePoint web application, you must wait until the Internet Information
Services (IIS) web site has been created on all servers. By default, no
New SharePoint site collections are created with the Web application.
If you have just created a forms based authentication (FBA) Web
Application, then before creating a new site collection, you will need
To perform some additional configuration steps.

Learn about how to configure a web application for FBA. 

Once you are finished, to create a new site collection, go toCreate site collectionPage. 

5. ClickCreate site collectionPage to move on to C. Site collection {SharePoint}

  C. Site collection {SharePoint}

1. EnterTitle for the site collection. Ssrsdemo for example.
2. ChooseTemplate.I will chooseBusiness Intelligence CenterBecause I want to store my SSRs reports in a bi related environment.
3. Enter a usernamePrimary collection Administrator. Make sure you enter the full domain name. e.g.: <domain name >\< username> (. \ USERNAME won't work here ).

D. SSRs integration {SharePoint}  

1. Go toSharePoint Central Administration website>
   General application settings> Reporting Services> reporting
   Services Integration.
2. EnterReport Server Web Service URLWhich you can find the SQL Server Reporting Services Configuration Manager.
3. ChooseAuthentication Mode. I will choose Windows authentication. Entering. \ <username> will do.
4. Go toSharePoint Central Administration website>
   General application settings> Reporting Services> Add a report
   Server to the Integration.
5. The server name shoshould already be provided and enter the name of the SQL server instance which hosts the Report Server database.
6. Enter the credentials.

  E. Upload a report {SharePoint}

2. Open your new top level Web site we created in C. Site collection {SharePoint}
4. In case you forgot the URL of the web site, goSharePoint Central Administration> Web ApplicationAnd look for the URL.
6. Go to all siteContent> documents.
8. In the ribbon, goLibrary tools> Library.
10. ClickLibrary settings.
12. ClickAdvanced Settings.
14. In content types, checkYesForAllow management of content typesAnd click OK.
16. In the columns section, clickAdd from existing site columns.
18. InSelect site columns fromDrop-down box, selectReport Server content types.
20. Select all available site content types and clickAddButton followed by OK.
22. Go backAll site content> documents.
24. ClickAdd document Link.
26. Browse for a report provided by the adventureworksdw200r2 samples from codeplex.
28. EnterTitleFor the report.

There is also the option to create a report yourself if you don't
Have the reports from the sample reports. It only takes a few seconds
Create a report using the report Builder (see screenshot below ).

You have now finished the complete setup. Click the report you have uploaded to view the result.