Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 Integration to SharePoint running on a Cluster Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 8:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 9:35 AM
Points: 1,277, Visits: 1,612
We have a named instance used for our SharePoint 2010 databases running on an active-passive cluster. (SQL Server 2008 R2-SP2 and Windows 2008 R2).
Named instance=SPCLST1\SharePT

We have a separate server dedicated to SSRS 2008 (SQL Server 2008 R2-SP2 and Windows 2008 R2). Default instance name=SSRSP1

We'd like to publish reports on SharePoint (SPCLST1\SharePT) that integrate with existing SSRS reports on SSRSP1.

From most of what I've read to appears that you have to install SSRS onto the server that hosts the SharePoint DBs, but because SharePoint is on a cluster, this isn't allowed. (I tried it and it didn't work)

Has anyone had any success getting this to work?

Thanks in advance.
Mike



Post #1413668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse