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 2012 configuration issue Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2012 9:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:53 PM
Points: 61, Visits: 207
I installed SQL 2012 Reporting Services – SharePoint and RS add-in for SharePoint products on separate server from the central admin called SSRServer. SharePoint is installed on the SSRS server but the central admin server is not on the SSRServe. When I run the SharePoint 2010 Management Shell to start the SQL Server Reporting Service, I get SQL Server Reporting Services Service is already started on SSRS server and when I go to the central admin site, the SQL Server Reporting Services Service is not there to start the service. I need the SQL Server Reporting Services Service to start on the central admin site and not on the SSRServer. Can you help please?
Post #1384724
Posted Thursday, November 15, 2012 6:11 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 1,980, Visits: 3,347
Hi Debora,

Not sure (as I don't use Sharepoint integration), but I think the RS Add-In needs to be installed on the Central Admin Server before it will appear on the Central Admin Site.

Thanks
Gaz
Post #1385113
Posted Thursday, November 15, 2012 4:49 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:53 PM
Points: 61, Visits: 207
Yes, that works. Thanks Gaz but now I am getting "This functionality is not supported because a Report Server URL has not been specified in Central Administration" when trying to specify a data source after deploying a report. Any idea?
Post #1385398
Posted Friday, November 16, 2012 3:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:55 PM
Points: 1,980, Visits: 3,347
Hi Debora,
Sounds like something's (RS URL?) missing in the Sharepoint RS config on the Central Admin Server - although I really am guessing in the dark now

There's some setup steps here - hopefully they'll be of use.
http://blogs.msdn.com/b/ritazh/archive/2012/01/23/install-and-configure-reporting-services-for-sharepoint-2010-integration.aspx

Thanks
Gaz
Post #1385577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse