SOLVED Config Mgr 2002 + SQL server 2017 (remote) -

[Manuel]

Hi to all

This error is an old one:


The information was published here;

Installing SQL Server 2012 for Configuration Manager 2012 R2

In this post we will be looking at the steps for Installing SQL Server 2012 for Configuration Manager 2012 R2. In this deployment series of

www.prajwaldesai.com

Note – If you are creating a Named Instance, then during the SCCM 2012 R2 setup you might come across this error “The specified SQL Server instance is not configured to use dynamic ports” unless you have not configured dynamic ports for SQL server instance. To fix this error launch the SQL Server Configuration Manager, expand SQL Server Network Configuration. Click on Protocols for Instance (Instance is your Named Instance). On the right side pane, right click on the TCP/IP and click on Properties. Click on IP Addresses tab and scroll down to the bottom and under the IPALL, set TCP Port value to 1433. Click on Apply and after this change you must restart SQL Server Service.

Do I have to only put 1433 to TCP PORT field? and delete the value located in the TCP Dynamic ports field?

or how do I have to make this change? of course, before I restart the name SQL instance service?

 

[Manuel]

I fixed, checking all the named instance and putting a different static port from others