SSRS 2012 configuration issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » SSRS 2012 configuration issue

SSRS 2012 configuration issue

Rate Topic

Display Mode

Topic Options

Author

Message

Debora

Posted Wednesday, November 14, 2012 9:25 AM

Valued Member

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:45 PM
Points: 60, Visits: 202

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

Gazareth

Posted Thursday, November 15, 2012 6:11 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

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

Debora

Posted Thursday, November 15, 2012 4:49 PM

Valued Member

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:45 PM
Points: 60, Visits: 202

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

Gazareth

Posted Friday, November 16, 2012 3:21 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

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 Smile

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 »

Permissions