SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SharePoint Integrated Mode not available in Report Manager


SharePoint Integrated Mode not available in Report Manager

Author
Message
shuk
shuk
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 152
Hey guys

We just upgraded our SQL Server to the new 2012 release.
So fare everything works fine.

We now tried to integrate the already existing Report Server (Native) into Sharepoint.
Therefore we added the features “Reporting Services – Sharepoint” & “Reporting Services Add-in for Sharepoint Products” to the existing Instance and of course we did the installation with “Reporting Services Sharepoint Integrated Mode”
A Sharepoint farm is already installed.

After the installation, we are still not able to switch the Report Server with the Configuration Manager from “Native” to “Sharepoint Integrated”. There is just no option which allows to switch the mode (see picture).



Does anyone face the same issue before?
Would be great if you can give me some help in that case.
shuk
shuk
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 152
Alright, I found the solution.
It's not possible anymore with SQL Server 2012 to configure Reporting Services for SharePoint in the Reporting Services Configuration Manager.
You have to use the Sharepoint Central Administration:

http://msdn.microsoft.com/en-us/library/gg492276.aspx#bkmk_install_SSRS_sharedservice
thamilanga
thamilanga
Old Hand
Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)Old Hand (307 reputation)

Group: General Forum Members
Points: 307 Visits: 230
I have the same problem. We have a SQL Server 2012 where the SSRS is installed and a separate SharePoint 2010 server. While installing SQL Server on the SQL box I did select both Reporting Services - SharePoint and Native but where I open Reporting Services Config Manager the SharePoint Integration Mode is not showing, I only have the native mode. When I try to run a new SSRS instance as a test, during the install test I can see the SharePoint Integration option which is ticked but greyed-out indicating that its already installed.

Does this mean on SQL 2012 if I want to run the SharePoint Integration Mode I have to install this on the SharePoint server?

Please assist.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search