Beside the regular culprits, an offline database will cause Intellisense to fail as well.
Detaching or bringing the offending database online will resolve the problem.