We are having a tough time with this, and I don't know who to ask since it overlaps with SQL and SharePoint, so I am hoping someone here has some insight for us!Quick version:
SharePoint 2010 has a special app called PrerequisiteInstaller.exe
that installs SP2010 prerequisites, including three SQL Feature Pack components: SSRS Add-in, ADO and SQL Native Client. But those prerequistes seem to be SQL Server 2008
-specific. We are using SQL 2012
, so we want to get PrerequisiteInstaller.exe to work with the SQL 2012 components. Does anyone know how to do this?Long version:
We have already built a nice SharePoint 2010 slipstreamed .iso with the latest Service Pack, Cumulative Update, and the SQL 2008 R2 prerequisites.
But now we would like to build a new .iso with the SQL 2012 with SP1 prerequisites for SharePoint 2010.
We tried this, but it fails.
It seems the problem is with the SharePoint 2010 PrerequisiteInstaller.exe not recognizing the new SQL 2012 SP1 files.
The three specific files are the SQL Native Client, ADO, and SSRS Add-in.
We tried to just use the same command line switches, but point to the new files. Our command lines look something like this:
/SQLNCli:file - Install Microsoft SQL Server 2008 Native Client from file
/SQLNCli:"C:\SP2010 Prerequisites\Microsoft SQL Server 2008 R2 SP1 Native Client\sqlncli.msi"
/ADOMD:file - Install Microsoft SQL Server 2008 Analysis Services ADOMD.NET from file
/ADOMD:"C:\SP2010 Prerequisites\Microsoft SQL Server 2008 R2 ADOMD.NET\SQLSERVER2008_ASADOMD10.msi"
/ReportingServices:file - Install SQL 2008 R2 Reporting Services SharePoint 2010 Add-in from file
/ReportingServices:"C:\SP2010 Prerequisites\Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint 2010\rsSharePoint.msi"
Just replacing the files with the corresponding SQL 2012 SP1 files does not seem to do the trick.
Might any of you encountered this? If so, might you know how to get this to work?
We really just want to get the SharePoint 2010 PrerequisiteInstaller.exe to recognize the new SQL 2012 SP1 files.
Any help or insight appreciated!