Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard

Problem:
Experiencing “Configuration Failed” error message while running SharePoint 2013 Products Configuration Wizard right after new installation/patching. It got stuck while performing configuration task 3 of 10. Creating the configuration database…
Configuration Failed: Failed to create the configuration database
Which ended with an error message:
“Configuration Failed: 
Failed to create the configuration database.
An exception of type System.Security.Principal.IdentityNotMappedException was thrown. Additional exception information: Some or all identity references could not be translated.”
Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard

Solutions:

  • Make sure SQL Server is running on a service account that is granted with local administrator access rights! (Not running on accounts such as local service, network service!)

    If so, update the Log On account of SQL Server Service in your database server.

    set sql server service account
  • Check TCP/IP and Named Pipes protocols are enabled in SQL Server. 
  • Check your Firewall. Turn it off for the time being. Check your event logs for any antivirus related blocks.  
  • Make sure your setup account (or the account you are currently logged in and running the SharePoint Products Configuration Wizard) is granted with: dbcreator, securityadmin and sysadmin access rights in SQL Server.
  • Check the application pool identity for the “SharePoint central administration” site! It should be your Farm account and not  “network service”
  • Do not use your service account username has with more than 20 characters (SharePoint uses the pre-windows 2000 username)
  • If all fails, Run PSConfig command line, and then try running the Products configuration Wizard GUI again!
    psconfig -cmd configdb <-create/connect> -server <db-servername> -database <database name> -user <service-account-username> -password <password> -admincontentdatabase <content database name>
  • Delete the config database in Database Server. Delete the Central admin site and App Pool in IIS. and try running the wizard again.

Rerun the SharePoint Configuration wizard after fixing the above workarounds.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

One thought on “Configuration Failed: Failed to create the configuration database in SharePoint Products Configuration Wizard

  • Hello, thanks for your help. I have a similar error, but is with database Name. I have a cluster and i put the name like: instancename.domain.com,1440 and the configuration continue but in the end fail. The error say the next: Se inició una excepción de tipo System.ArgumentException. The exception instancename.pre.domain.com,1440 is not valid or do not is a loopback address.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *