Switching Reporting Services from Native to Sharepoint Integration mode - 2012 Business Intelligence
In SQL Server 2012, you no longer set up an SSRS instance which you can then choose to be in standalone or integrated mode. Instead, you need to run the SQL Server installer and choose to install SSRS in integrated mode onto a server that's part of your SharePoint farm (for example an app server). This creates a new SharePoint managed service that really is a part of SharePoint, not a separate service at all. The SSRS SharePont mode install is, confusingly, listed in the Shared Components section of the install choices. Hope this helps, DuncanDuncan Sutcliffe All postings are solely my own and do not represent or constitute Hitachi Consulting's positions, views, strategies or opinions.
July 9th, 2012 10:03am
All Shared Components are installed. Is there additional configuration I need to do?
July 9th, 2012 10:20am
In that case the SSRS configuration tool is redundant - you manage SSRS through the managed services page in Sharepoint Central Admin. The installer may not have actually created a service app for you, in which case you need to go to the managed services page and choose New -> SQL Server Reporting Services Application. DuncanDuncan Sutcliffe All postings are solely my own and do not represent or constitute Hitachi Consulting's positions, views, strategies or opinions.
July 9th, 2012 10:24am
Thanks Duncan, I've overlooked some key documentation somewhere. Is this one of those features that requires farm instead of standalone installation?
July 9th, 2012 11:05am
I am fairly sure it would work fine on a standalone implementation. This page is a good jumping-off point: http://technet.microsoft.com/en-us/library/hh231676(v=sql.110).aspx DuncanDuncan Sutcliffe All postings are solely my own and do not represent or constitute Hitachi Consulting's positions, views, strategies or opinions.
July 9th, 2012 11:16am
I think Standalone install is my problem after reading through this. http://technet.microsoft.com/en-us/library/hh231680.aspx#bkmk_sp1
July 10th, 2012 11:54am
Hi rk7997, Duncan is absolutely right. In SQL Server 2012 Reporting Services, the SharePoint mode has been changed from a Windows Service to a SharePoint Shared Service. Since you have installed all the features of SQL Server 2012 Shared Features, you can go ahead and create a Reporting Services Service Application from the SharePoint Central Administration Web Application as Duncan described above. For the detailed steps, please see the Create a Reporting Services Service Application section of the following article: http://msdn.microsoft.com/en-us/library/gg492276(v=sql.110).aspx#bkmk_create_serrviceapplication For your concern about the SharePoint installation type, I would like to explain that either Standalone installation or Server Farm installation is okay. It is recommended to select the SharePoint farm installation type because the infrastructure required by some BI features like Power View is only supported in a farm installation. For a common development environment of Reporting Services, the standalone installation of SharePoint is OK. If you have any questions, please feel free to let me know. Regards, Mike Yin
July 11th, 2012 4:51am
Thanks Mike, I think I'm getting closer. I'm still stuck on section in your link Create a Reporting Services Service Application steps 2 thru 10. I was putting in the wrong information. I am still putting in the wrong information, but now it is getting farther in the process, creates the report server db and bombs out with what appears to be a problem with permissions on a registry key. Permissions on the key look fine for local admins. If I use Windows Auth instead of stored credentials it doesn't get far and says the login fails, though the user looks like it has full rights to sql, sharepoint, and local admin on the server.
July 11th, 2012 10:38am
The login failed message when not using SA says failed for DOMAIN\COMPUTERNAME$ I don't type it in like that anywhere.
July 11th, 2012 10:47am
Just to keep anyone that might be watching this updated, I successfully created the SQL Server Reporting Services service on a fresh server install in farm mode. It is either required to be farm mode or we messed up our Standalone install at some point.
July 11th, 2012 4:46pm
When I try to switch from native to Sharepoint Integration mode in the Reporting Services Configuration manager, I never get the option to change from Native mode. It always appears to be a forced setting. I go to "Change Database" and select "Create a new report server database" and the Report Server Mode is always Native with no ability to change it to Sharepoint Integrated. I'm sure it's something obvious, but can anyone give me any suggestions or tell me what I am doing wrong? Thanks.
July 15th, 2012 3:54am
Also, I've installed all Report Server options with the initial SQL installation.
July 15th, 2012 4:00am