I have an Azure database, SSMS 2012, and VS 2013. I have created the appropriate logins and users for myself and a colleague using the server login to access the Azure database. However, for reasons unknown to me, I can only access the database through SSMS. In VS I can access and login into the server just fine. But, when we click to expand the database, it produces and 'x' and denies showing any related tables, etc. Yet, from SSMS all is accessible with no problem. My colleague can access the database on his machine via SSMS or VS 2013 Community Edition. The problem seems to exist on only my machine and only with respect to the created logins. I can access the database fine using the admin credentials. I have attempted reinstalling VS, but it hasn't helped. Thoughts from anyone?
It turns out I cannot access the database because the Azure db I created is the 2014 (v12) version. I have SSMS 2012 (v11) loaded on my machine which is not compatible with the v12 db. Hence, the issues. The short of it is: I need to update to SSMS 2014 and reload VS afterwards since it partially relies on SSMS.