Sharepoint frontend and SQL 2008/SSRS on different servers

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?
LVL 1
dparkesAsked:
Who is Participating?
 
abhitrigCommented:
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
0
 
abhitrigCommented:
You would need the SS R2 Addin and then the SP object model on the SSRS machine. These links should help:
http://msdn.microsoft.com/en-us/library/bb677365.aspx
http://msdn.microsoft.com/en-us/library/aa905869.aspx
0
 
dparkesAuthor Commented:
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.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
dparkesAuthor Commented:
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.
0
 
dparkesAuthor Commented:
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.
0
 
dparkesAuthor Commented:
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.
0
 
dparkesAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.