There are many ways to setup SSRS for SharePoint integration. In this post, we will describe steps to configure SSRS for SharePoint on multiple servers. In particular, when Reporting server is installed on the SharePoint server.
First computer is the SharePoint server. We will need to install Reporting services and Reporting services add-in on the SharePoint server:
Configure Reporting services on SharePoint server
Configure SSRS add-in in SharePoint Central Admin
Create Reports and publish to Reports library
To ensure Reports run using a service account, instead of the user:
Very good article! Thanks for posting it.
Best walk through I've found on this subject. Keep these great posts coming!
better then MSDN.. very good post..
Its really much better then MSDN
One Question : in the 3rd screen shot where you are entering the name of SQL instance when installing SSRS , are you using the same name as your SQL DB Engine/Analysis server is using ( which is on second computer) ?
Further Down you said "◾ensure you enter the SQL instance you are running on the SQL server (not the default value given on the SharePoint server)" So that tells me that you are using a different instance name when installing SSRS on SP Server ( First Computer) ?
thanks for the post , it was helpful.
in my case, I installed SSRS components on the SharePoint server (first computer). So the server name is the SharePoint server name and the Report Server Instance in my case was "REPORT". Further down, in "Reporting Services Configuration Manager", I had to connect to:
Server Name: SharePoint server name (First computer)
Report Server Instance: REPORT
Hope this helps!
Thanks for responding back!
So you have installed SSRS on SharePoint server, lets call this instance "SharePointServer\Report".
You have one instance on SQL server ( second computer) for your DB Engine lets call it "SQLServer\InstanceName" as per blog when you open configuration manager on SharePoint Server ( computer one) you said ""ensure you enter the SQL instance you are running on the SQL server (not the default value given on the SharePoint server)"" but as per your response you are entering SharePointServer\Report.
Can you please help me understand this ? need to do the same thing but its kind of confusing..
Aso , if I want to use SSAS do I need to move SSAS on SharePoint Server as well or it can be use while sitting on SQL server ( second computer)?
Thanks for nice post!!!
It helps me lot.
Excellent guide. Minor issue with the Sharepoint Configuration page where it prompt for the credentials to use for the reporting services.
The account needs to be an account that has administrator access to the computer where the reporting services is installed, not the service that reporting services uses.
The description the product has doesn't help distinguish the difference.