If we choose "Standalone" option for SharePoint 2010 installation, although the server already have SQL Server 2008 R2 installed, but SharePoint will still install SQL 2008 Express for us
If we choose "
Server Farm" and then "
Complete" install, when come to Configuration Wizard, we will get error message like "Local accounts should only be used in stand alone mode"
To overcome this problem, we need to use "SharePoint 2010 management shell" (in the same locations as the central admin link)
Under the Start Menu, browse to "Microsoft SharePoint 2010 Products". Right-click on "SharePoint 2010 Management Shell" and choose "Run as administrator"
(Notice: Since we have not created a farm yet, the shell will load with error that the local farm is not accessible. This is expected.)
Simply type "
New-SPConfigurationDatabase" and press enter
Please provide new database name, database server (computer name), and passphrase.
"Passphrase" is new password for you to manage your farm later
Notes:
If anything fails, close and reopen PowerShell (SharePoint 2010 management shell)
Use your servername in the FarmCrentials section (ServerName\Username)
Next, open again "SharePoint 2010 Product Configuration Wizard" to complete the installation