Source: MSSQL$MICROSOFT##WID Event ID: 28005
by Sorean on Aug.07, 2019, under Database Related
Source: MSSQL$MICROSOFT##WID
Event ID: 28005
An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.
Download SQL Management Studio, run as admin, connect to \\.\pipe\microsoft##wid\tsql\query
Run: sp_helpdb
Windows Internal Database shows unknown owner for AdfsArtifcatStore and AdfsConfiguration.
Change the DB owner to a service account or a local account depending on your usage. In my case it was a service account ‘domain\serviceaccount’.
