--- title: "Connect to WSUS Database: Fix SCCM Software Update Point" description: "Learn to connect to a WSUS database and run queries to resolve issues with your SCCM software update point." canonical: "https://adamtheautomator.com/connect-to-wsus-database/" --- # Connect to WSUS Database: Fix SCCM Software Update Point > Learn to connect to a WSUS database and run queries to resolve issues with your SCCM software update point. Source: https://adamtheautomator.com/connect-to-wsus-database/ --- ATA Learning Tap to hide [ ATA Learning ](/) * [Home](/) * [Tutorials](/tutorials/) * [Instructors](/author/) * [Advertising](/advertising/) * [Recommended Resources](/resources/) * [About Adam](/about-adam/) Search for: * [](https://twitter.com/adbertram) * [](https://github.com/Adam-the-Automator) * [](https://www.linkedin.com/company/adam-the-automator-llc) * [](/feed/) ![Connect to WSUS Database: Fix SCCM Software Update Point](https://adamtheautomator.com/wp-content/uploads/2019/06/unable-to-connect-to-wsus-database-solved-sccm.png) # Connect to WSUS Database: Fix SCCM Software Update Point [![](https://secure.gravatar.com/avatar/d0b9d42e21e5622713f8b693aa5c0f9244d5f7dd200ed29b8398f52dee5de337?s=192&d=mm&r=g)Adam Bertram](https://adamtheautomator.com/author/adam-bertram/)17 June 20191 min. read Categories: [IT Ops](/category/it-ops/) Tags:[SCCM](/tag/sccm/)[WSUS](/tag/wsus/) 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. Related:[How to Backup an SCCM Site Server with PowerShell](https://adamtheautomator.com/sccm-backup-site-server/) 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](https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility) of the [SQL Management Studio](https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms). > _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](http://www.microsoft.com/en-us/download/details.aspx?id=7593) 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_. ```powershell sqlcmd -S np:\\.\pipe\MICROSOFT##WID\tsql\query ``` 5\. If it connects, execute the query below. ```sql 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. Share this article [Share on X](https://twitter.com/intent/tweet?url=https%3A%2F%2Fadamtheautomator.com%2Fconnect-to-wsus-database%2F&text=Connect%20to%20WSUS%20Database%3A%20Fix%20SCCM%20Software%20Update%20Point)[Share on Facebook](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fadamtheautomator.com%2Fconnect-to-wsus-database%2F)[Share on LinkedIn](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fadamtheautomator.com%2Fconnect-to-wsus-database%2F) ## Related Posts ![](https://adamtheautomator.com/wp-content/uploads/2021/06/How-to-Patch-Offline-Computers-with-the-WSUS-Offline-Update-Tool.jpg) ### [How to Patch Offline Computers with the WSUS Offline Update Tool](/wsus-offline-update/) Learn how to install all of those missing updates on a completely offline Windows computer with the WSUS Offline Update utility! ![](https://adamtheautomator.com/wp-content/uploads/2019/06/5d238ae5c824b514689ea5b1.jpg) ### [Decipher SCCM Client Logs with PowerShell](/sccm-client-logs/) Read and interpret SCCM client logs effortlessly using PowerShell. Step-by-step guide inside. ![](https://adamtheautomator.com/wp-content/uploads/2026/07/featured_image-4.png) ### [Migrate from EWS to Microsoft Graph API](/migrate-ews-microsoft-graph-api/) Move EWS mailbox automation to Microsoft Graph with a practical inventory, permissions, PowerShell SDK, and cutover validation checklist. ## Categories * [IT Ops](/category/it-ops/) * [Cloud](/category/cloud/) * [DevOps](/category/devops/) * [Home Ops](/category/home-ops/) * [Information Security](/category/infosec/) * [Software Development](/category/software-development/) ## Site * [Home](/) * [Tutorials](/tutorials/) * [Instructors](/author/) * [Advertising](/advertising/) * [Recommended Resources](/resources/) * [About Adam](/about-adam/) Copyright 2026© ATA Learning | [Privacy Policy](/privacy/)