Monday, June 27, 2011

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.


  • 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.

No comments: