Forum Discussion

Scoko2's avatar
Scoko2
Copper Contributor
Oct 31, 2023

SCCM Service Connection Tool Failed to Connect - ConnectionString Matter

Hello any SCCM Expert,

 

I need help for the below issue with Service Connection Tool. I need to know how to set my connection string from TrustServerCertificate=False to True

 

Reference Article: https://techcommunity.microsoft.com/t5/core-infrastructure-and-security/updating-configuration-manager-in-offline-mode-with-the-service/ba-p/1410282 

 

I am trying to run ServiceConnectionTools for Offline Installer for my setup below.

 

My Lab Setup is a follows:

1. SCCM Primary Server: CM01  (No Internet Access - Internal LAN)

2. MS SQL Server: DB01  (No Internet Access - Internal LAN)

3. Upstream WSUS Server: WSUS01 (Have internet access - in DMZ)

4. CA Server: CA01   (No Internet Access - Internal LAN)

 

ON MY CM01

I have Created in C Drive C:\Temp Folder for temporary gather of the SCCM Infra. Once gathered collected it will be transferred to a USB drive.

 

I have copied the ServiceConnectionTool into the C:\Temp as shown below

I have also created a folder named UsageData

 

 

Cd into C:\temp\serviceConnectionTool

 

I run the Command below:

ServiceConnectionTool.exe -prepare -usagedatadest c:\temp\UsageData\UsageData.cab

 

The Operation completed with an an ERROR: Can not connect to the Database. Please refer to the log file....

 

Go into the ServiceConnectionTool > Open the ServiceConnectioToo.log

The Logs as captured

Below the Extracted Contents from above except hostname and ID changed:

 

INFO:Logged-in account name: Sccm_admin
INFO:Running as account name: Lab\Sccm_admin
INFO:Telemetry Prepare step is running
connectionString: :Persist Security Info=False;Integrated Security=true;Encrypt=True;TrustServerCertificate=False;Initial Catalog=CM_LB1;server=HomeLab-CM-DB1.lab.local\SCCM
ERROR:System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)

 

Anybody know how to.

Thank you.

 

Regards,

Scoko



No RepliesBe the first to reply

Resources