We are trying to install a new MECM standalone primary server with a remote SQL Server.
SQL is SQL Server 2016
SQL Native Client is version 11.4.7462.6
SQL Auth is mixed mode
We are using the MECM 2103 Baseline but we are seeing the following issue when trying to install:
INFO: Setup downloader setupdl.exe: FINISHED $$<Configuration Manager Setup><06-22-2021 12:41:04.124-120><thread=11784 (0x2E08)>
INFO: Checking SQLNCli version on ServerName $$<Configuration Manager Setup><06-22-2021 12:43:23.629-120><thread=14168 (0x3758)>
INFO: Failed to open registry key SOFTWARE\Microsoft\SQLNCLI11 on . Error = 2 $$<Configuration Manager Setup><06-22-2021 12:43:23.644-120><thread=14168 (0x3758)>
SQL native client is not installed. $$<Configuration Manager Setup><06-22-2021 12:43:23.676-120><thread=14168 (0x3758)>
INFO: Registered type MASTER for master $$<Configuration Manager Setup><06-22-2021 12:43:23.691-120><thread=14168 (0x3758)>
INFO: Registered type SMS Master for master $$<Configuration Manager Setup><06-22-2021 12:43:23.707-120><thread=14168 (0x3758)>
INFO: Registered type CM_ for CM_ $$<Configuration Manager Setup><06-22-2021 12:43:23.722-120><thread=14168 (0x3758)>
INFO: Registered type SMS ACCESS for CM_ $$<Configuration Manager Setup><06-22-2021 12:43:23.754-120><thread=14168 (0x3758)>
[28000][18452][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. $$<Configuration Manager Setup><06-22-2021 12:43:23.801-120><thread=14168 (0x3758)>
[28000][18452][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. $$<Configuration Manager Setup><06-22-2021 12:43:23.816-120><thread=14168 (0x3758)>
Failed to connect to the SQL Server, connection type: MASTER. $$<Configuration Manager Setup><06-22-2021 12:43:23.847-120><thread=14168 (0x3758)>
[28000][18452][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. $$<Configuration Manager Setup><06-22-2021 12:43:23.879-120><thread=14168 (0x3758)>
[28000][18452][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. $$<Configuration Manager Setup><06-22-2021 12:43:23.894-120><thread=14168 (0x3758)>
Failed to connect to the SQL Server, connection type: *** MASTER. $$<Configuration Manager Setup><06-22-2021 12:43:23.910-120><thread=14168 (0x3758)>
I have redacted the servername & sitecode with ***
Has anyone come across this before?


