SCCM - SQL Server Security

Question

Hi

I haver posted that before but I dont got really good answer. I trying to install SCCM Site server, error:

The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.

XXX; SQL Server security mode; Warning; The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.

I have installed SQL server on another server and Site Server there is WSUS installed that pointed to SQL Server.

SQL Server and Site server have that open ports:

8531 TCP Any (null)
8530 TCP Any (null)
1688 TCP Any (null)
8530 TCP Any (null)
2701 TCP Any (null)
445 TCP Any (null)
443 TCP Any (null)
4022 TCP Any (null)
1433 TCP Any (null)
1434 UDP Any (null)
32400 TCP Any (null)
135 TCP Any (null)

I have also that settings with SQL:

Error

Any idea what I can do ?

Answer 1

Hi again ,

It seems to be something wrong about the SQL Server 2019 .. I will trying to install SQL server 2019 again, but Its your guide , [https://www.recastsoftware.com/resources/how-to-install-sql-server-2019/ for outside SQL Server to SCCM ?

// :-)