[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Sharepoint frontend and SQL 2008/SSRS on different servers

Posted on 2011-05-11
Medium Priority
Last Modified: 2012-05-11
This is my first foray into Sharepoint (WSS 3.0) and I'm trying to get SSRS reports running on the front end Sharepoint system, whereas now they are on a different server. I am not familiar with the concept of farms but I have a feeling I will need to be in order to get this working.

When I say 'front end' I mean the site we can access remotely outside our intranet.

So I have this...

Server 1)
Sharepoint Front End (works fine, but cannot view reports)

Server 2)
SQL Reporting Services, 2008 R1 (full version), in Sharepoint integrated mode (works fine, but not accessible from front end)

In Server 1 Central Administration, I tried setting "Grant Database Access" to the report database on Server 2, but got the error "Unable to connect to the Report Server WMI provider" so I'm thinking this was not the correct solution.

Does anyone know how these servers are supposed to connect?
Question by:dparkes
  • 5
  • 2
LVL 14

Expert Comment

ID: 35740693
You would need the SS R2 Addin and then the SP object model on the SSRS machine. These links should help:

Author Comment

ID: 35741339
Thanks for the reply!  It looks like I already have the SSRS Addin installed on Server 2.  

Where would I obtain the SP Object Model?  Is it a download that has an installer, or is it part of something else?

Sorry but the webpages are confusing me.  The link "How to: Install a SharePoint Web Front-end on a Report Server Computer" is not what I want to do -- I'm sure it is helpful but it's hard for me to follow since that does not  describe what I 'think' I want.  Sorry I'm just confused.
LVL 14

Accepted Solution

abhitrig earned 2000 total points
ID: 35741378
Well you are not alone to be confused, We all are in the same boat when it comes to the SSRS integration :)

How to: Install a SharePoint Web Front-end on a Report Server Computer" is what you will have to do to install the SP object model on the SSRS server.
Install the SharePoint on that server and then attach it to the existing farm using the SharePoint Configuration Wizard.

Another option (not so integrated though) is to display the reports using the page viewer webpart
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.


Author Comment

ID: 35741769
Is it possible I might have to uninstall and reinstall Sharepoint on the SSRS server?  When I first installed I did not select the Server Farm option. Now the Configuration Wizrd does not ask me any questions when I run it.

Author Comment

ID: 35742009
I went ahead and uninstalled and reinstalled SP so I would get the Web Frontend Server Farm option this time.  I'll report back in a bit.

Author Comment

ID: 35742872
Well I feel like I performed all the steps but the Report content types are still not available, which of course is the ultimate goal.  Obviously I missed something.

Author Comment

ID: 35750195
I see the Reports content types available in Central Administration, but not on the Sharepoint site itself.  Since I got this far, it seems that I do have the two server setup running like I needed.  This seems like a separate issue, so I'll close this question and open another.  Thanks.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question