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.

Evidence that SP1 is required

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.

    Error in farm configuration wizard

  • In the PowerPivot Configuration Tool, the tool fails to create the farm.

    Error in configuration tool

Problem Resolution

Download and install SharePoint Server 2010 SP1. Reboot is required. If the farm already exists, you must run upgrade actions in the farm to fully patch all of the servers. After SP1 is applied, you can retry the operation you were attempting when the error occurred.