Post reply

SSRS 2012 configuration issue

  • November 14, 2012 at 9:25 am

    #270160

    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?

  • November 15, 2012 at 6:11 am

    #1559321

    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

  • November 15, 2012 at 4:49 pm

    #1559560

    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?

  • November 16, 2012 at 3:21 am

    #1559708

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply