Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problems with install / configure SSRS 2012 in SharePoint mode with SharePoint 2010 Expand / Collapse
Author
Message
Posted Thursday, August 09, 2012 9:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 07, 2014 5:01 PM
Points: 100, Visits: 249
We are trying to install and configure SQL Server Reporting Services (SSRS) 2012 in SharePoint mode with SharePoint (SP) 2010 on a separate SP app VM. We followed the Microsoft install check lists:

- http://technet.microsoft.com/en-us/library/hh231676(v=sql.110).aspx
- http://technet.microsoft.com/en-us/library/gg492276.aspx
- http://technet.microsoft.com/en-us/library/cc281311.aspx
- http://technet.microsoft.com/en-us/library/hh479775.aspx

which mostly went well but had a few minor issues. Once we got past some issues with the SSRS 2012 add-in for SP on all SP app and web VMs in the SP farm, we ran into issues getting the SSRS instance recognized by the SP farm using the requested SP Central Administration commands or the SP PowerShell admin commands.

I understand that SSRS 2012 instances work differently in SharePoint mode than prior SSRS instances – run and managed as SharePoint services (especially important for scale-out load balance scenarios). In prior SSRS versions, an SSRS SharePoint mode install would install SSRS OS service(s) on the selected system (visible in the services management tool – under Administrative Tools), and then use the SSRS service(s) in the context of the SP farm.

After our recent successful SSRS 2012 install (no errors for the main SSRS component – only errors for the SSRS add-ins that were later resolved), there were no SSRS OS services installed on the selected SSRS 2012 install system. Since I have not yet experienced a successful SSRS 2012 SharePoint mode install, I don’t know if this lack of SSRS 2012 OS service(s) is normal / expected or is a possible source of the current issues.

I wonder if the SSRS 2012 install check list from Microsoft mentioned above may be incomplete – possibly missing some tasks.

Some questions:

- Has anyone successfully installed SSRS 2012 in SharePoint mode with SharePoint 2010?

- Are there any additional steps / tasks that must be done beyond what is mentioned in the Microsoft SSRS 2012 check lists (mentioned above or other lists)?

- Should a SSRS 2012 instance in SharePoint mode with SharePoint 2010 install SSRS 2012 OS services (as was done by SSRS 2008 R2 and earlier versions)?


Thanks in advance for any insights and help you can provide.

Scott R.
Post #1343120
Posted Saturday, November 09, 2013 3:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:16 AM
Points: 1, Visits: 34
Refer to the following blog for step by step guide for installing ssrs 2012

[url=http://gallery.technet.microsoft.com/office/Instalating-and-Configuring-9a38de94][/url]
Post #1512937
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse