Tallan's Technology Blog

Tallan's Top Technologists Share Their Thoughts on Today's Technology Challenges

Installing SharePoint 2010 SP2

Chris Magrane

I was tasked last week with learning how to install SharePoint 2010 as part of our SharePoint IT Training Module.  It’ll be easy they told me, or maybe they didn’t tell me that and I told myself that.  It’s only an installation, how hard can it be?  Famous Last words.  Well after a long time setting up every little thing I get hit with this error and spend a day trying to get past it trying a number of different strategies :

————————————————————–
– Checking farm membership for SP2010-TRAINING in “SP_Config”…Not joined yet.
– Attempting to join farm on “SP_Config”…
– No existing farm found.
– Creating config database “SP_Config”…
New-SPConfigurationDatabase : Could not find stored procedure ‘sp_dboption’.
At C:\SP\AutoSPInstaller\AutoSPInstallerFunctions.ps1:1651 char:40
+             New-SPConfigurationDatabase <<<<  -DatabaseName “$configDB” -Data
baseServer “$dbServer” -AdministrationContentDatabaseName “$centralAdminContent
DB” -Passphrase $secPhrase -FarmCredentials $farmCredential @distCacheSwitch
+ CategoryInfo          : InvalidData: (Microsoft.Share…urationDatabase:
SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SqlExce
ption
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon
figurationDatabase

————————————————————-

 

 

So basically the issue is that SharePoint 2010 SP2 does not come with the pieces that SP1 comes with, and it relies on those pieces, hence not being about to find the stored procedure “sp_dboption”.  So let’s fix this issue and still be able to install it with Auto SP installer in one pass. First we need to do a few things to get it ready to be installed again.

 

Make sure to go into SSMS and connect to your SharePoint SQL Server and delete the Configuration DB that it started creating and failed, just cleaning up the failed Configuration part. Right click your Config DB, again mine is called SP_Config, and click delete.  Then make sure to check off Close Existing connections.

deletingDB

 

If you don’t do this you will see this error message in your script :

 

————————————————————–
– Checking farm membership for SP2010-TRAINING in “SP_Config”…Not joined yet.
– Attempting to join farm on “SP_Config”…
– No existing farm found.
– Creating config database “SP_Config”…
New-SPConfigurationDatabase : SP_Config on SPDB contains user-defined schema.
Databases must be empty before they can be used.  Delete all of the tables, sto
red procedures and other objects or use a different database.
At C:\SP\AutoSPInstaller\AutoSPInstallerFunctions.ps1:1651 char:40
+             New-SPConfigurationDatabase <<<<  -DatabaseName “$configDB” -Data
baseServer “$dbServer” -AdministrationContentDatabaseName “$centralAdminContent
DB” -Passphrase $secPhrase -FarmCredentials $farmCredential @distCacheSwitch
+ CategoryInfo          : InvalidData: (Microsoft.Share…urationDatabase:
SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SPUncle
anDatabaseException
+ FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon
figurationDatabase

————————————————————–

So make sure to do that.

 

You will also need to uninstall SharePoint since we are going to Install it fresh again, because that is where this issue comes from.  Just go into your Program List, find SharePoint, and Uninstall like you would uninstall any other program.

 

Now you will need an iso or exe of SharePoint2010 SP1.  Then you will need to extract/copy all the pieces into the “SP\2010\SharePoint\” folder.  This is all you need to do to get past this issue, after all of that is copied over and set up it’s time to run the AutoSPInstallerLaunch.bat file again!  Now if everything is done correctly you should see this happy message:

 

————————————————————–
– Checking farm membership for SP2010-TRAINING in “SP_Config”…Not joined yet.
– Attempting to join farm on “SP_Config”…
– No existing farm found.
– Creating config database “SP_Config”…
– Done creating configuration database for farm.
————————————————————–

Yay job well done!  Now as far as Provisioning services and the rest of the set ups and configurations, that isn’t covered in this post.  I had no more issues after I reached this point and SharePoint was configured and installed and ready to go!

 

Good Luck with your installation, please post any comments or issues if you come across them below.

 

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>