Forum Discussion
Scoko2
Oct 31, 2023Copper Contributor
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