Following on from my previous post about Project Server and PerformancePoint in a multi-tenanted environment, realised that I had not told the whole story!
I neglected to include this when I wrote the above, Excel Services is another critical part of Project Server (more so than PerformancePoint really), and although it does have some support for Multi-tenancy it is far from perfect.
In short, when you configure Excel Services (no partitioning options are available) it does appear to honour subscriptions in the configuration, ie you can use a tenanted Secure Store to create Excel Services Application IDs, however the catch is that it will only talk to the Secure Store in the Default proxy group!
This presents a problem, as you read above PerformancePoint also only talks to the Default Secure Store, however unlike Excel Services PerformancePoint can not talk to a tenanted Secure Store app in the default group so you are left with a catch 22. Either both Excel Services and PerformancePoint can work together using a NON-tenanted default secure store, or one or the other cannot be installed!
*sigh*
If this stuff were simple we wouldn’t be here would we?
Martin,
Thanks for the heads-up on the multi-tenancy issues…both Project and PPS are key applications for us. We are right now setting up a small SharePoint server farm to host them. Your blog couldn’t be more timely and is now shifting our attention to a workaround. Any more news/ideas would be most welcome as we wait with you for a fix from Microsoft.
Ed Kiely
Martin,
Nice blog! Wondering if you have any experience instaling SSRS integrated w SP2010 in multi-tenant environment? Trying to find out if lack of SSRS availability in Sharepoint Online of Office365 is a technical limitation due to some complexity with authentication between the two or if there’s another reason. MS has been silent on this and I don’t understand the multi-tenant auth in O365 well enough to guess the reason. Your thoughts?
Thanks,
Josh
Hi there,
I have configured SSRS in a multi-tenant farm, and yes your guess is correct the SharPoint add-in doesn’t appear to be tenant aware, but in fact SSRS is really a separate application altogether effectively with a “plug-in” to SharePoint. So I can imagine why MS has not included it in Office 365..
Martin,
Thanks for your reply. Do you know of any good discussions or documentation around SSRS w SP2010 multi-tenant? Any insight into why/how 3rd party hosters can provide SSRS with SP multi-tenant, but MS cannot? i.e. accesshosting.com
Josh
Not much more I can say on that, other than posting on the appropriate TechNet forum, maybe.
Martin.