If you're struggling with getting your SCCM software update point to sync with WSUS, prepare yourself to see what I've done to fix it.

The latest issue is now I couldn't access the Windows Internal Database to run any kind of maintenance script. When trying to connect either via sqlcmd or SQL Management Studio via my logged in Windows credentials I was receiving the error system cannot find the file specified when attempting to connect with the server name nb:\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query and the error login failed when connecting with the server name nb:\.\pipe\MICROSOFT##WID\tsql\query. Also, event ID 18456 - Token-based server access validation failed with an infrastructure error... was being generated in the Application event log along with Login failed for user.... server is in script upgrade mode in the C:\Windows\WID\Log\error.log.

Microsoft support suspected problems with the WID so we had to get SQL access to it. To anyone that's trying to access the WSUS Windows Internal Database via SQL Server Management Studio Express and cannot get connected, here's what I had to go through:

  1. Download and install SQL Server Management Studio Express.
  2. Open up SQL Server Configuration Manager and go to Native Client 11.0 Configuration -> Client Protocols and ensure TCP/IP is enabled.
  3. Connect to database on command line via sqlcmd -S np:\\.\pipe\MICROSOFT##WID\tsql\query.
  4. Execute the query:
SELECT session_id
from sys.dm_Exec_requests
where 
	status <> 'sleeping' and
    session_id <> @@spid
    
SELECT @@spid

This is used to figure out the account that has access

For some reason, this fixed the connection issue and we were now able to connect!