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.
- Download and install SQL Server Management Studio Express on your SUP server.
- Open up SQL Server Configuration Manager.
- Click on Native Client 11.0 Configuration -> Client Protocols and ensure TCP/IP is enabled.
- 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.
More from Adam The Automator & Friends