Connect to WSUS Database: Fix SCCM Software Update Point

Published:17 June 2019 - 1 min. read

Sometime’s Microsoft’s Endpoint Manager (MEM) formally System Center Configuration Manager (SCCM) doesn’t behave. Sometimes, more specifically, the software update point (SUP) starts to not sync with WSUS and you need to connect to the WSUS database.

SUP uses a Windows Internal Database (WID) to store update metadata. The WID is part of the synchronization system to WSUS. When troubleshooting, you can connect to the WID to determine what’s going on. But you might run into the below error when connecting with sqlcmd of the SQL Management Studio.

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.

If you’re receiving the above error when connecting to a WID, follow the below steps. It might help.

  1. Download and install SQL Server Management Studio Express on your SUP server.
  2. Open up SQL Server Configuration Manager.
  3. Click on Native Client 11.0 Configuration -> Client Protocols and ensure TCP/IP is enabled.
  4. Now open up a command prompt and attempt to connect to the database with sqlcmd.
sqlcmd -S np:\\.\pipe\MICROSOFT##WID\tsql\query

5. If it connects, execute the query below.

SELECT session_id
from sys.dm_Exec_requests
where 
    status <> 'sleeping' and
    session_id <> @@spid
    
SELECT @@spid

If that query works, you should now be able to connect to your WSUS database! For whatever reason, Microsoft provided me this query and after executing it, I was able to connect to the WSUS database. All was fine after that.

Hate ads? Want to support the writer? Get many of our tutorials packaged as an ATA Guidebook.

Explore ATA Guidebooks

Looks like you're offline!