Troubleshoot SharePoint farm configuration errors related to SP1 requirement
If you are using SQL Server 2012 features with a SharePoint farm, you must apply SharePoint Server2010 Service Pack 1 (SP1) to the farm before adding SQL Server 2012 features. Pre-SP1 version of SharePoint 2010 uses a deprecated feature that was removed in Microsoft SQL Server 2012 . Applying SP1 adds a new methodology for connecting to SQL Server 2012 features.
This section describes the errors that will occur if SP1 is not installed. Errors are most likely to occur when you create a farm or update information in the configuration database. The following list summarizes the more common ways you will encounter this error.
In ULS logs, you will find the following error: Could not find stored procedure 'sp_dboption'.
In the SharePoint Products Configuration wizard, the wizard fails to create the configuration database.
In the PowerPivot Configuration Tool, the tool fails to create the farm.