|Solved|SCCM-Setup is unable to connect to SQL Server with the connection information provided

Recently i was Installing on Microsoft System Center Configuration Manager 2012 R2. I used to install the system center by every step but at some point i got an error where i was so much confused to have error like this

Setup is unable to connect to SQL Server with the connection information provided.

The SQL Server and instance names are entered correctly

The specified SQL Server instance is not configured to use dynamic ports

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

Resolution:

After working on this error i was successfully able to resolve this error that i was facing. Kindly follow the below mentioned points to solve your problem

1- Go to the SQL Server Configuration Manager.

2- Go to the SQL Server Network Configuration and then click Protocols for SQLINSTANCENAME

3- Go to the properties of TCP/IP

4- Clear all the TCP Dynamic Ports field to blank and enter 1433 to all the TCP Ports like in the given screenshot and then restart the SQL SERVER Service .

Thanks !!!! Hope it will work for you Guys