IntelliSense is not working in SQL Server Management Studio

Question

We use SQL Server Management Studio 2008 R2. IntelliSense works with SA account perfectly. But it is not working with Windows Authentication user. The user has access master db with db_owner role but it's not sysadmin.

How do I fix this issue?

Answer 1

You can try solution from these questions1 or questions2 and questions3.
Or please try these steps as below:

• Enable IntelliSense:
  • For all query windows, please go to Tools >> Options >> Text Editor >> Transact-SQL >> IntelliSense, and select Enable IntelliSense.
  • For each opening query window, please go to Query >> Intellisense Enabled.
• Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes.
• Refresh IntelliSense local cache: please go to >> Edit >> IntelliSense >>Refresh Local Cache or use the CTRL+Shift+R keyboard shortcut to refresh.
• Wait a minute or two for the Refresh to finish before trying again.

Answer 2

I had the same issue. Everything was enabled to ensure proper Intellisense functions, but didn't work. I realized I had SQLCMD mode enabled by default. Disabling it restored Intellisense functionality :)