PENDING Deploy SCCM with a workgroup wsus server

[Christian96]

I am trying to deploy sccm with a workgroup wsus server. After finishing deploying SCCM cannot get the updates from the wsus server. i have this error:
*** [28000][18452][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
*** [28000][18452][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
*** Failed to connect to the SQL Server, connection type: SMS ACCESS.

And the following line I have this notification:
Done using %machinename%\administrateur credentials
WSUS Server configuration has been updated. Updating Group Info.
Updating Group Info for WSUS.
Refreshing categories from WSUS server
Using %machinename%\administrateur credentials for network connections
Attempting connection to WSUS server: sccmserver.domain.local, port: 8530, useSSL: False
Successfully connected to server: sccmserver.domain.local, port: 8530, useSSL: False SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:35:54 8976 (0x2310)
Done using %machinename%\administrateur credentials SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:02 8976 (0x2310)
Successfully refreshed categories from WSUS server SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:02 8976 (0x2310)
Using %machinename%\administrateur credentials for network connections SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:07 8976 (0x2310)
Attempting connection to WSUS server: sccmserver.domain.local, port: 8530, useSSL: False SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:07 8976 (0x2310)
Successfully connected to server: sccmserver.domain.local, port: 8530, useSSL: False SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:07 8976 (0x2310)
Category Product:30eb551c-6288-4716-9a78-f300ec36d72b (Office 365 Client) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category Product:569e8e8f-c6cd-42c8-92a3-efbb20a0f6f5 (Windows Server 2016) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category Product:a3c2375d-0c8a-42f9-bce0-28333e198407 (Windows 10) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category Product:c96c35fc-a21f-481b-917c-10c4f64792cb (SQL Server Feature Pack) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category Product:d31bd4c3-d872-41c9-a2e7-231f372588cb (Windows Server 2012 R2) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category ProductFamily:23f5eb29-ddc6-4263-9958-cf032644deea (System Center Online) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category ProductFamily:504ae250-57c5-484a-8a10-a2c35ea0689b (Office Communications Server And Office Communicator) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Category ProductFamily:b567e54e-648b-4ac6-9171-149a19a73da8 (Microsoft Security Essentials) not found on WSUS SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Done using %machinename%\administrateur credentials SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Using %machinename%\administrateur credentials for network connections SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Attempting connection to WSUS server: sccmserver.domain.local, port: 8530, useSSL: False SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Successfully connected to server: sccmserver.domain.local, port: 8530, useSSL: False SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Done using %machinename%\administrateur credentials SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)
Waiting for changes for 60 minutes SMS_WSUS_CONFIGURATION_MANAGER 30/01/2024 11:36:08 8976 (0x2310)

 

[Garth]

Why is WSUS in a workgroup? The very first line you posted is telling you the error that you need to fix.

 

[Christian96]

we did not want it to be in the domain for security purpose since he is supposed to be exposed to the internet.

 

[Garth]

we did not want it to be in the domain for security purpose since he is supposed to be exposed to the internet.

are you not going to have your ConfigMgr server connected to the internet? E.g. CMG? It will be required to be within a domain

Imo having workgroup computers for security is an old way of handle security.

 

[Christian96]

Yeah, you are right but it is really difficult for my manager to understand that it is an old fashion of handling security.