Hossein Zahed

Web Developer, Entrepreneur, Software Educator

SharePoint 2013 Configuration Wizard Error

SharePoint 2013 Configuration Wizard Error – The specified user is a local account . Local account should only be used in stand alone mode

I was going through installation of SharePoint 2013 on my local machine as a Single Server farm (both SP and Database on same server) 

Its a VM setup on Hyper-V with the following environment: 

  • Windows Server 2012 R2
  • SharePoint 2013 SP1
  • SQL Server 2012 SP2 

After installation of SQL Server and SharePoint, I was going through the SharePoint Configuration Wizard. When I tried to create a new farm, I got “Specify Confguration Database Settings” page, where I typed the DB Server, DB name, Username and Password. But when I clicked Next, I got this error

 “The specified user is a local account . Local account should only be used in stand alone mode” 

Since I dont have a domain or AD setup here, I had to go with a different route. 

I opened the SharePoint 2013 Management Shell from Windows Server Metro Tiles and typed the following:

Dont panic if it takes longer to get to the prompt, as it has to create the Admin and the ConfigDB in the Database.

Once complete, you can reopen the Configuration Wizard and run again. You will now see the Database as configured before and can proceed with next steps.

Install and Download SharePoint 2013 prerequisites offline (Manually)

This article applies in a situation when you don’t have internet access in your SharePoint server , I have placed all the direct download links for the installers you might need.

This article assumes you are having a new fresh installation of windows server 2008 R2 SP1 / 2012 R2  

If you tried to run the installer , The following should be installed (but you cant install them directly from here since you don’t have internet)

in this case  you can download and install SharePoint 2013 Prerequisites offline and run them manually as below:

I have placed what needs to be installed on a clean Window server 2008 R2 SP1 / 2012 R2 , you should not need more than this:

Prerequisite Direct Link

Microsoft .NET Framework 4.5

(Full Stand alone package)

http://go.microsoft.com/fwlink/?LinkId=225702

Or

Download tFx45_Full_x86_x64.exe from stand alone section from

http://msdn.microsoft.com/en-us/library/5a4x27ek.aspx

Windows Management Framework 3.0

http://www.microsoft.com/en-us/download/details.aspx?id=34595

Microsoft SQL Server 2008 R2 SP1 Native Client

Download 1033\x64\sqlncli.msi from

http://www.microsoft.com/en-us/download/details.aspx?id=26728

Windows Identity Foundation (KB974405)

http://go.microsoft.com/fwlink/p/?LinkID=226830

Windows Identity Extensions

http://go.microsoft.com/fwlink/?LinkID=252368

Microsoft Sync Framework Runtime v1.0 SP1 (x64)

http://go.microsoft.com/fwlink/p/?LinkID=224449

Windows Server AppFabric

http://go.microsoft.com/fwlink/?LinkId=235496 

(Note: don’t install WindowsServerAppFabricSetup_x64_6.1 this is not the correct version that

SharePoint installer seeks)

 

Download it but don’t install it by yourself since it needs configuration, hence install all other

prerequisites in this article (except this one) then let the prerequisite installer to install AppFabric

and configure it manually for you by running the following command from command prompt:

prerequisiteInstaller.exe /appfabric:[Full AppFabric Installer path]

 

D: is the CD drive where SharePoint installer is placed

 

Microsoft Information Protection and Control Client

http://go.microsoft.com/fwlink/p/?LinkID=219568

Microsoft WCF Data Services 5.0

http://www.microsoft.com/en-us/download/details.aspx?id=29306

Cumulative Update Package 1 for Microsoft AppFabric 1.1 for Windows Server (KB2671763

Download AppFabric1.1-RTM-KB2671763-x64-ENU.exe from

http://www.microsoft.com/en-us/download/details.aspx?id=29241

You need to Install AppFabric from above first then run this update,

dont run this update if appFabric above is not installed yet