Installing Configuration Manager 2012 (SCCM) into a SQL instance you receive a cannot connect to SQL Server Error Message

Got this little beast on error yesterday. Was rather annoyed that the error message gives you so many possibilities as to what the error is. 

Error = Setup is unable to connect to SQL Server with the connection information Provided. Verify the following
The SQL Server and instance names are entered correctly
The Specified SQL Service Instance is not configured to use dynamic pots
If a firewall is enabled on the SQL Server, inbound rules exist to allow connections to the correct ports
The account used to run Setup has permissions to connect to the specified SQL Server instance.


How to fix this error: The reason for this error is because Configuration Manager 2012, does not support dynamic ports, so you need to go to SQL Server Configuration Manager and set that named instance to use the static Port and restart the SQL Server Service

For more detail on whats going on click below.


http://blogs.msdn.com/b/scom_2012_upgrade_process__lessons_learned_during_my_upgrade_process/archive/2012/07/04/configuration-manager-2012-setup-error-_3a00_-setup-is-unable-to-connect-to-sql-server-with-the-connection-information-provided.aspx