SharePoint 2010: PowerShell New-SPConfigurationDatabase : The user does not exist or is not unique.

When running a PowerShell workaround to get SP2010 installed on a standalone Server 2008 R2 machine [here.] I came across a new error.

New-SPConfigurationDatabase : The user does not exist or is not unique. At line:1 char:28 + New-SPConfigurationDatabase <<<< + CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase: SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SPCmdle tException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon figurationDatabase New-SPConfigurationDatabase : The user does not exist or is not unique. At line:1 char:28 + New-SPConfigurationDatabase <<<< + CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase: SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], COMExce ption + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon figurationDatabase

A fewposts I found out there seemed to be focused on the particular version of the Geneva Framework installed. That was not the root cause for me. The solution I got to work was to:

  1. Create a new local user “svc_sharepoint”
  2. Add it to the Administrators group
  3. Delete the Config and AdminContent databases via SQL Server Management Studio
  4. Reopen PowerShell and run New-SPConfigurationDatabase with the following
  • DatabaseName: SharePoint2010_Config
  • DatabaseServer: [SERVERNAME]
  • FarmCredentials [SERVERNAMEACCOUNT]
  • PassPhrase: [PASSWORD]

Notes:

  • If anything fails close and reopen PowerShell
  • Use your servername in the FarmCrendtials section