Thank you. Looking at the databases about three have service broker set as false or 0. Would this be the cause of the message? Also, does it need to be...

The owner belongs to a domain account of person who set it up. The account is still active. However, the message occurs every 15 minutes.

Created a listener. The first time it failed over there was still one database that was registering the errors on the secondary. It cleared later. A couple of other failover...

Will give that a shot and update the forum. Thank you!

No listener configured.

Sorry sabiralvi. Didn't see you message until now.

Changing the user to a different domain based account helped with the error.

There is another database that gets installed during the install of the ADFS. The ex employee is an owner there as well. The account is not present in the domain...

sp_helpdb showed the "owner" of the database as "domain\ex-employee".

So, I would

ALTER AUTHORIZATION ON DATABASE::yourdb TO betterowner to rectify. I am thinking the better owner in this case should be the...

Executed

The first column header is "(No column name)" and is NULL. Some other attributes are

name   : IdentityServerNotificationsQueue

principal_id  : NULL

activation_procedure : [dbo].[IdentityServerNotificationCleanup]

Executed

Select USER_NAME(principal_id), * FROM sys.service_queues WHERE name = 'IdentityServerNotificationCleanup'

From the adfsconfiguration database. It returns just the column headers. The version of SQL is 2008 r2.

Thank you very much for the response and that too detailed.

I right clicked the dbo.IdentityServerNotificationsQueue -> Script Queue as -> Alter to -> New Query Editor Window

Then noticed the "execute...