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:
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!
