asked on

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?

abhitrig

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

dparkes

ASKER

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.

ASKER CERTIFIED SOLUTION

abhitrig

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dparkes

ASKER

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.

dparkes

ASKER

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.

dparkes

ASKER

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.

dparkes

ASKER

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.