Cannot open backup device. Operating system error 5(Access is denied.). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

Came across this error while trying to restore a SQL database backup which was stored in a container to Azure SQL managed instance.

Operating system error 5(Access is denied.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

The blob would connect properly and show the backup file.

Solution:

Deleted the stored credentials in the database and did the process again for restoring backup.

SQL intellisense not working

The following are not a sequence of steps. You can try each one of these and something might work.

Check if you have  intellisense enabled.

 

If the Intellisense is not working only for certain databases.Keep the top check box enabled but remove the underline errors and outline statements.  Open a new query window and check.

  Disable SQLCMD mode.

 

Refresh Local Cache.