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:
- Download and install SQL Server Management Studio Express.
- Open up SQL Server Configuration Manager and go to Native Client 11.0 Configuration -> Client Protocols and ensure TCP/IP is enabled.
- Connect to database on command line via sqlcmd -S np:\\.\pipe\MICROSOFT##WID\tsql\query.
- 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!