There are a couple of adfs servers (pri and sec) with backend adfsconfiguration database. This was installed by an ex-employee and that user is the database owner (account does not exist in AD anymore). However, the ADFS service runs on a service account and that service account also owns the schema for IdentityServerPolicy in database and is a user within the database. Please NOTE that ADFS service has been functional and is not down.
On a reboot of the SQL server we started seeing the following in the sql logs. It wasn't happening before and started after a reboot of sql. And this is logged every few seconds flooding the current log file.
The activated proc '[dbo].[IdentityServerNotificationCleanup]' running on queue 'AdfsConfiguration.dbo.IdentityServerNotificationsQueue' output the following: 'Could not obtain information about Windows NT group/user 'mydomain\ex-employee', error code 0x534.'
In Service Broker -> Queues of the database there is dbo.IdentityServerNotificationsQueue which has a procedure name IdentityServerNotificationCleanup.
I would like to clear this message from queue or at ignore this specific one.
Any help is appreciated. Thanks much.