Security for a day

Ran in to an odd problem with my Forefront console.

On shutting down my Forefront SQL server, it hung and needed a hard reboot. Server came up cleanly and seemed to be fine. That was until I attempted to start the Forefront console. It looked like it was trying to load, but nothing did and after a few minutes, pop up an error:

No go on loading the Forefront Console

An error occurred during view refreshing. Verify that you have successfully completed the Configuration wizard and have permission to access the management server.

Further details:

Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Warning: The join order has been enforced because a local join hint is used.

Well, not what I wanted. After much searching the web, i found a number of unhelpful links talking about checking permissions and re-installing. I focused on the last statement

Warning: The join order has been enforced because a local join hint is used.

This is a SQL warning, so trotted over to our SQL guru for some guidance. Jim checked the SQL logs and found nothing but saw some jobs hanging. So as good practice suggested I run DBCC CHECKDB against the Onepoint and SystemCenterReporting databases.

The checks both came up clean, but the console was working again!