Dieser Artikel steht nur in englisch zur Verfügung.
Part 1: Installing SQL Reporting Services
Part 2: Configuring Reporting Services
Part 3: Installing PowerPivot for SharePoint
Part 4: Configuring PowerPivot for SharePoint
Part 5: Configuring PerformancePoint Services
After installation is completed successfully open the Reporting Services Configuration Manager using your SharePoint Farm Account (this may require membership of local).
Select the SQL Server and Instance on which you installed the Reporting Services.
Select Web Service URL, you may change the Virtual Directory name. Click Apply.
Select Database and click on Change Database to Create a new report server database. Click Next.
Check the Database Server field. Choose your Authentication Type (normally Integrated Security is used). The user for this action should be the SharePoint Farm account. Click Next.
Adjust the Database Name to meet your companys naming conventions. Select the SharePoint Integrated Mode and click Next.
Use the Service Credentials. Click Next, Next, Finish.
Select Report Manager URL, you may change the Virtual Directory name and click Apply.
You may also configure the other tabs, but they are not needed for our purpose at this time.
Make sure that the SQL 2008 R2 Reporting Services SharePoint 2010 Add-in is installed on the SharePoint server. http://www.microsoft.com/en-us/download/details.aspx?id=9437
Open the SharePoint Central Administration and click on General Application Settings > Reporting Services > Reporting Services Integration. Enter the Report Server Web Service URL which you defined in the SQL Reporting Configuration Manager. If you are not using Kerberos authentication, you must select Trusted Account as Authentication Method. Enter you SharePoint Farm account credentials and click OK.
After the Reporting Services are successfully configured on the SharePoint server you should see this:
Go to your Site Collection (on which Web Application you activated Reporting Servies earlier) and activate the following:
Under Site Collection Features
Under Site Features
You can now start building your reports.