Navigate Up
Sign In

SQL 2012 Reporting Services Gotchas with SharePoint 2010

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.

You may also be interested in: Documentation Toolkit for SharePoint

 

Editor's note: Contributor Paul Hunt is a SharePoint Solutions Architect at Trinity Expert Systems. Follow him @cimares

Back in March of 2012, Liam Cleary wrote an excellent guide to installing SQL 2012 Reporting Services into a SharePoint 2010 farm in integrated mode. (You can find that post here.)

I’ve recently been using that guide to produce a proof of concept for a client, to show that I would be able to install SQL 2012 Reporting Services into their environment and what the steps would be. This PoC has highlighted a couple of gotchas that Liam’s post didn’t encounter or highlight, so I wanted to raise them here.

Scenario Synopsis: Installing SQL 2012 Reporting Services on a new server that is being integrated with an existing SharePoint 2010 farm.

Gotcha Number 1

You cannot use Windows Server 2012 to host the SQL 2012 Reporting Services engine as you need to install the SharePoint 2010 binaries on this server. SharePoint 2010 SP1 does not currently support Windows Server 2012. This support will arrived with SharePoint 2010 Service Pack 2, however at the time of writing, there is currently no release date for this Service Pack.

Ref: http://support.microsoft.com/kb/2724471

Gotcha Number 2

When installing the SharePoint binaries onto the server that you will be installing the SQL 2012 Reporting Services engine, you must ensure that you copy the deployment method for the original SharePoint servers.

E.g. if you built on RTM and then updated to SP1, you must not use a slipstream media containing SP1 as this appears to cause an issue with some core language pack files not being upgraded. This error can only be surmounted by uninstalling the SharePoint binaries and following the original install method.

This error will come to light as soon as you try and run PSConfig to join the Reporting Services server into the existing farm.

2013-06-10-SQL2012ReportingSharePoint2010-01.png

Gotcha Number 3

All SharePoint 2010 servers must be running Windows Server 2008 R2 Service Pack 1 in order to be able to install the SQL 2012 Reporting Services Add-in onto all servers in the farm.

This error will show up when you try and run the SQL 2012 install media on the existing SharePoint servers.

Gotcha Number 4

SharePoint 2010 must be running Service Pack 1 (14.0.6029) in order to install SQL 2012 Reporting Services in SharePoint integrated mode.

Gotcha Number 5

The edition of SQL used to install the Reporting Services engine, MUST match that used to install SQL for SharePoint. E.g.SQL 2008 R2 Enterprise must have SQL2012 Enterprise Reporting Services. in order to avoid this error when trying to configure SQL Reporting Services in the Farm.

"The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services."

It’s possible that you may be able to mitigate this issue by installing the database engine at the same time as installing the Reporting Services engine, and pointing the databases onto this instance during the creation of the service application, but I haven’t tried this yet!

You can use the following SQL query to ascertain which version and edition of SQL you have installed on the SharePoint SQL server.


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

In Summary

Following Liam’s original post, and taking into account these gotchas above, I now have a perfectly deployed SQL 2012 Reporting Services instance running in Integrated mode in my 2 year old SharePoint 2010 development farm. I’m quite happy that this proves the process for my client and will form the basis of my process document for their team to follow.

My next step, and probably my next blog post will be taking this to the next level and integrating SQL 2012 PowerPivot for Excel and PowerView!

Regards
Paul.

Categories: SQL; Reporting; SharePoint; MOSS; WSS; 2010

Comments

 hyundai t7

Android tablet pc

Free shipping android tablet pc and smartphone with high quality and cheap price.<a href="http://www.trustedbuyonline.com/cube-u30gt-2-quad-core-rk3188-101-inch-mid-tablet-pc-fhd1080p-ips-screen-android-41-2g-32g-bluetooth-white_p1197.html"> cube u30gt 2</a>

Posted 17-Jul-2013 by hyundai t7
Chanel iPhone 4s Case

Chanel iPhone 4s Case

Hey There. I found your blog using msn. This is an extremely well written article. I'll be sure to bookmark it and come back to read more of your useful info. Thanks for the post. I'll certainly return.Chanel Galaxy S3 Case

Posted 25-Jul-2013 by Chanel iPhone 4s Case
Battery Manufacturer

Battery Manufacturer

NiMH,NICD,LITHIUM,LIPO,LiFePO4 Battery,Battery Pack Manufacturer-EJ Technology Battery Manufacturer

Posted 06-Aug-2013 by Battery Manufacturer
becca

Seo Sevices Melbourne

It is nice to definitely dig up a website where the blogger is intelligent. Thanks for creating your web site.

Posted 14-Aug-2013 by becca
Tony Covarrubias

SSRS Drill Through Doesn't Work

We've also gone to this confiuration however, we have not been able to get drill through functionality to work properly. We have reports with text boxes which act as a psuedo hyperlink. The text box property is modified under "action" to go to a report. This works in that the report is launched. However, the parameters on the called report are not behaving as they are in the stand alone implementation of SSRS. Example, the called report has a parameter with a given default value. When drill to, this report throws an error stating that the parameter value cannot be blank (it should not as there is a default value set).
 
Have you seen this yet?

Posted 20-Aug-2013 by Tony Covarrubias
mary

Soleil blanc robe axe essentiel de la réussite

L'Europe doit finalement garde-robe robe blanche d'une femme , ils pensent tous les deux peuvent assister à toutes les grandes occasions , Casquette Last King Blanc peut également porter au code vestimentaire quotidienne. Ils aiment le costume , coupe de OnePiece , ou les deux en avez, vous pouvez aussi venir avec une modélisation supplémentaire .

Posted 10-Oct-2013 by mary
alksdsajdksfs

alksdsajdksfs

Swiss watch brand Alpina Replica Watches continues development of its watches with the arrival at the end of the year Fake Breitling watches 2013, the Alpina Extreme Diver 1000 orange. Timer imposing 44 mm steel housing Replica Rolex uk water resistant 300 meters that houses the automatic mechanical gauge that displays its black dial particularly legible.

Posted 16-Apr-2014 by alksdsajdksfs

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: