I added some notes about heaps and you may find that useful.

Back To Basics: Heaps

CI has to be choosen carefully as you can have only one per table. You don't...

Do you know for which user you are getting this error message? If yes, Then go to the security -> Logins, right click on the user, go to properties, Database...

Can you check the Authentication mode set for the server. Go to Enterprise Manager, right click on the server, go to properties, go to Security Tab.

Reposting to make it less annoying to read.

Whenever I have to switch to a different database in my DEV server, if I click the 

dropdown box, it...