question

noobdba avatar image
noobdba asked

ADFS Configuration database dbo.IdentityServerNotificationsQueue

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.

BUT,

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.

sql-server-2008-r2userqueue
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.