MS: SharePoint 2010 Configuration Failed - Failed to Create the Configuration Database

When you try to configure SharePoint 2010 to connect to a SQL Server using a non standard port, you will receive an error: Failed to create the configuration database.

An exception of type System.ArgumentException was thrown. Additional exception information: [Server Name or IP Address],[Port] is an invalid or loopback access. Specify a valid server address.

Solution:

• Open odbcad32 tool.



• Select the System DSN tab.



• Add a new System Data Source: SQL Server.



• Type the SQL server name on both Name and Server fields on the fist page.



• On the second page, click on the Client Configuration button, unchecks the Dynamically Determine Port checkbox and enter the port number.