I need to plan a SQL Server 2012 + SP 1 installation on a new machine.
I've read somewhere that for PowerPivot for SharePoint (2013) it is better to use the slipstream file and not the upgrade file to install after SQL Server 2012 RTM. Certainly using slipstream for a new SQL installation is more comfortable than upgrade, but I've read an explicit difference between them.
In these links I haven't found any references:
Use the Product Updates feature if you want to install SQL Server 2012 + SP1. Please read the following article:
Hope this helps.
Hi Alberto, thanks for your reply.
However, the SP 1 is downloaded separately.
I've read (and I don't remember where!) an explicit reference to use the slipstream for PowerPivot for SharePoint or other Business Intelligence feature, because with slipstream having SP 1 is to be able an architecture and this isn't possible with the update file.
Unfortunately, I don't remember where I've read a such article.
pscorca, I am also looking for guidance from Microsoft SQL that states the requirement to use slipstreamed installation of SQL 2012 that includes SP1 when installing the BI features on SharePoint 2013. I am sure it exists, I just can't find it. I have learned from experience that the RTM media does not allow you to install the BI features on SharePoint 2013 even with the product updates feature enabled - you get the bits for SharePoint2010 installed instead.
There are several blog posts that just assume you know that slipstreamed media is required - http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx is an example. Unfortunately, there is little guidance on this from the Microsoft documentation, they just state that SQL 2012 with SP1 is a requirement for the SharePoint 2013 BI features, they don't exclude the product updates path or mention that applying SP1 or a post-SP1 CU will not upgrade the BI features (PowerPivot and Reporting Services in Integrated Mode for example) to work with SharePoint 2013.
If anyone finds an MSDN article that expands upon the information in Product Updates in SQL Server 2012 Installation http://msdn.microsoft.com/library/hh231670.aspx to include the scenario of installing SQL 2012 with SP1 BI features for SharePoint 2013, please reply so we all have it. Thanks