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

SQL 2012 with SharePoint 2010 question! Expand / Collapse
Author
Message
Posted Wednesday, January 9, 2013 7:12 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 7:49 AM
Points: 119, Visits: 926
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!
Post #1404759
Posted Thursday, May 23, 2013 2:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 23, 2013 2:46 AM
Points: 3, Visits: 42
Yes I did too. It seems that there is no equivalent of this for SQL 2012, and you just install SP 2010 with sqlserver2008_asadomd10.msi.
Post #1455890
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse