Wednesday, April 16, 2014

Could not find stored procedure ‘sp_dboption’ when Installing SharePoint Farm with SQL Server 2012

Yesterday, I was trying to install SharePoint Farm on my computer with SQL Server 2012. Everything ran smoothly until I started the SharePoint 2010 Products Configuration Wizard. Initially, the wizard asked me DB Name and other details but suddenly while it was processing it threw an error:
Failed to create the configuration database. An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: Could not find stored procedure ‘sp_dboption’.


After a bit of reading I found that SharePoint Server 2010 needs SP1 to be installed before I could configure it with SQL Server 2012.
I reached to the Microsoft Knowledge Base article : , downloaded the SharePoint Server 2010 SP1 and executed it.
The setup of SP1 took 5-7 minutes and then after the SP1 setup, I restarted my computer. once again I executed “SharePoint 2010 Products Configuration Wizard” at this time it worked like magic.
Hope this helps.
I will post some more articles . Keep in touch and have fun. :)