WSUS – Connection to SUSDB

Posted by robd on March 07, 2017
SQL

Today I wanted to migrate the WSUS server to a SQL server and as such you have to connect to:

\\.\pipe\MICROSOFT##WID\tsql\query

But I kept getting:

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.

Long story short I opened SQL Management Studio as the local admin (not my domain admin) and bobs your uncle.

Tags: ,

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Copy Protected by Chetan's WP-Copyprotect.