SharePoint 2010 with SQL Server 2012

sqlserver2012

With the RC0 release of SQL Server 2012 I have been seeing more and more people interested in testing it with SharePoint 2010. If you attempt to install SharePoint 2010 with a SQL Server 2012 database you may receive an error message related to a missing stored procedure.

SQL Server 2012 removed the system stored procedure sp_dboptions. This is a required stored procedure for installing SharePoint 2010 RTM. Service pack 1 for SharePoint 2010 does eliminate the dependency for the sp_dboptions stored procedure.

To install SharePoint 2010 on SQL 2012 you will need to ensure that you have the SharePoint 2010 with Service Pack 1 installer or you will need to slipstream the service pack so that it is included in the RTM build of SharePoint.

Check out the following blog post if you need instructions on how to slipstream a service pack into the SharePoint 2010 RTM.

http://blogs.msdn.com/b/ronalg/archive/2011/07/11/slipstream-sharepoint-2010-sp1-and-language-packs-w-sp1-into-rtm.aspx

Note: Official support of SharePoint 2010 on SQL 2012 has not been announced by Microsoft.

 

No comments

No comments :

Post a Comment