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.
Leave a Reply