Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problems with install / configure SSRS 2012 in SharePoint mode with SharePoint 2010


Problems with install / configure SSRS 2012 in SharePoint mode with SharePoint 2010

Author
Message
Scott Russell-302661
Scott Russell-302661
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 Visits: 300
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.
avi_cs21
avi_cs21
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 35
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]
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