Error :: Configuration Failed :: Failed to create configuration database; The password supplied with the username was not correct

By jeanpaulva On January 29, 2013 · 2 Comments

I was receiving the following error while installing SharePoint.

• SharePoint 2010
• Windows Server 2008 R2
• SQL Server 2008 R2
• Active Directory

The installation went fine, but running the Products & Configuration wizard, the error appeared and spoiled the game.

I error says “Password was not correct”.  I ensured the password was right.

Playing around & I found that the user was not added to Administrators group.  Following is the fix:

Solution

Create a new user spadmin

Eg: DOMAINspadmin

Ensure the Password policy as Never expires.

Add the user to Administrators group

Inside Active Directory window, right click on the user & choose the Add to Group option.

Click Ok to continue.

Assign SQL Server Permissions

Now open your SQL Server & choose Security>Logins. 

If you cannot find the spadmin user, add using New Login option.  Ensure you set the following Server Roles as well

      

Click the Ok button save changes

Back in SharePoint Products & Configuration Wizard

Back in the wizard, use the new spadmin user in the format DOMAINspadmin

The error should not appear this time.  Good Luck!

Ref:  http://www.jeanpaulva.com/index.php/2013/01/29/error-configuration-failed-failed-to-create-configuration-database-the-password-supplied-with-the-username-was-not-correct/