Installing SharePoint 2010 Server Enterprise

When trying to set up a single SharePoint server farm. During SharePoint configuration wizard, I try to put in a local account for 'Database Access account" and get prompted with below message.


The specified user [USER NAME] is a local account. Local accounts should only be used in stand alone mode

SP is right. advanced configuration allows the creation of a farm in which we can then connect other servers, such as for indexing, sending mail or other stuffs .. and of course, a local account on the machine where we are installing the product is not able to "switch" between a server and the other becouse is not a domani account.

But if we are sure we use put everything on this local server. We can create the farm with PowerShell.Below are the steps.

1. Under the Start Menu, browse to Microsoft SharePoint 2010 Products.  Right-click on SharePoint 2010 Management Shell and choose Run as administrator
2. Run command New-SPConfigurationDatabase
3. Follow prompts and specify values for the farm. You will be prompted to pick a user to data access, that is where you can use a local account. ( Or specify them in the parameters. e.g.,New-SPConfigurationDatabase  –DatabaseName “SharePoint2010_Config” –DatabaseServer “<db server>” –AdministrationContentDatabaseName “SharePoint2010_Admin_Content” –Passphrase (ConvertTo-SecureString “pass@word1” –AsPlaintext –Force) –FarmCredentials (Get-Credential)

That Powershell command creates a new configuration database within SQL Server for SharePoint and it will be the basis of our new farm. In fact, starting again the utility "SharePoint Products Configuration Wizard", it will notice the presence of a SharePoint farm and so enable us to proceed with the installation.