Unable to connect to WSUS Server

[MagnumVP]

 

The SMS_ISVUPDATES_SYNCAGENT.log is showing "Unable to Connect to local WSUS Server" every minute ans has been for days (the log only goes back 3 days and it's full with these messages).
I recently performed an in-place upgrade from 2012 R2 to what is now 1910 with Hotfix. So far everything seems to be working as expected but notices this last night and I'm not sure where to look.

I can connect to the local SQL DB where WSUS DB is located and connect to the SCCM DB as well.

This is the only Software Update point and syncs with MS directly.

 

However, the WCM.log shows a success.

[MagnumVP]

I think I have found the underlying issue. The server was upgraded from 2008 R to 2012 R2 and the WSUS DB wasn't uninstalled prior to upgrade. The WSUS is corrupted (Update Service won't start as one issue). I'm going to work on rebuilding the WSUS DB using this link I found. Hopeful it fixes it.

https://www.richardwalz.com/sccm-reinstall-wsus-susdb/

I'm considering upgrading to Server 2016 prior to fixing so I don't have to worry about this again in 2023.

[anyweb]

good luck and let us know how you get on with it

[MagnumVP]

Steps I took so far...which looks promising.

1. Removed the Software Updates Roles from SCCM - Monitor SUSSetup.log
2. Rebooted
3. Removed WSUS as described in the link. 
4. Rebooted
5. Updated OS to Server 2016
6. Installed WSUS as described in the link using SQL default Instance
7. Do NOT run the Post install command....yet.
8. Open Services and change W3SVC and WAS to automatic (default is DISABLED) and start
9. Run the post install SQL script to create the directories and DB
10. Open IIS verify Application Pool WsusPool and WSUS Administration Site is created.
11. Install Software Updates Roles within SCCM (MECM now) - Monitor SUSSetup.log
12. Perform Software Sync - Monitor with WCM.log and wsyncmgr.log

hopefully the initial sync completes without issues.  Fingers crossed. 

 

EDIT:  Looks to be syncing just fine. 

[anyweb]

good to hear it !