Issue SharePoint 2013: The username is invalid. The account must be a valid domain account

Audience

Everyone

When configuring SharePoint 2013 in “Complete” mode you get a “The username is invalid. The account mist be a valid domain account” when using a local account to configure the farm…

image_thumb[15]
Figure: You need a domain to create a farm

The implication is that only Domains are supported.

Applies To

  • SharePoint 2013

Findings

Out of the box SharePoint only supports “Stand-alone” mode for non domain environments, but this forces you to use SQL Server 2008 R2 Express Edition which is most cases is unacceptable.

image
Figure: “Stand-alone” used SQL Server 2008 R2 Express Edition

The UI is designed for the happy path and you need to drop to the command line to do anything else.

Solution

Use a PowerShell command to create the initial configuration of the farm with a local account:

  1. Start the SharePoint PowerShell
  2. Run “New-SPConfigurationDatabase” from the command line and follow the instructions

    image_thumb[16]
    Figure: New-SPConfigurationDatabase creates the farm for you

    This will create the farm and configure the necessary accounts.

  3. Rerun the Configurtion wizard

    After it finishes start the Config Wizard (interactive or not) and configure your server with all components

    image_thumb[17]
    Figure: Just don’t disconnect from this server farm

This works just fine with SQL Server 2012.

Did this help you?

Create a conversation around this article

Share on Facebook
Share on Twitter
Share on Linkdin

Read more

Martin Hinshelwood
For a long time now I have been searching for that perfect domain that epitomised the vision, the why, of what I am trying to achieve with my customers and the industry at large. Now I have found it in http://nkdagility.com
Martin Hinshelwood
At the MVP Summit I was appalled by the number of people who asked questions about new features for supporting hierarchical tasks! I shared a disgusted look with Peter Provost and we had a quick (and I mean really quick) conversation that resulted in this post. it really comes down …
Martin Hinshelwood
In my journey of delivering an immersive Product Development Mentor Program over the last eight weeks, a compelling narrative unfolded that beautifully illustrates the essence and true strength of Scrum. This story, rooted in the practical application of Scrum through Minecraft, unveils the depth of adaptability and resilience that Scrum …
Martin Hinshelwood
The Boards in Azure DevOps are a powerful tool that your teams can leverage to enable transparent visualization of the current state of value delivery.  However, the inclusion of Blocked columns can stealthily erode the very foundations of efficiency these boards are meant to uphold. By obfuscating the state of …