SQL Intellisense not working? Maybe you have an offline database.

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.