'Server Explorer' > 'Windows Azure' > 'SQL Databases' in VS2013 does not show any databases
azure, azure-sql-database, visual-studio-2013
Solution
SQL Databases do not yet support the OAuth signon in Visual Studio and they still require a management certificate to interact with them in VS. If you right-click the Windows Azure node in the server explorer tree and select Manage Subscriptions you can then switch to the Certificates tab and import a management certificate.
Problem
According to: http://blogs.msdn.com/b/visualstudio/archive/2013/10/23/windows-azure-sdk-2-2-release.aspx The SQL Database node is a welcomed addition to the Windows Azure Server Explorer. Now you can browse your SQL Azure databases without knowing the virtual machine or connection string to the database. We automatically configure the firewall so that you can access the database from your developer workstation. You can also open your SQL Azure database in SQL Object Explorer for a complete database management experience. However, I have added a SQL Database in my Windows Azure Management Portal but it does not appear in Server Explorer, the SQL Databases branch is completely empty. I also have a Web Site which does show up in Server Explorer. Any ideas what the problem is? I've tried refreshing and restarting Visual Studio, and signing out and back in again. I thought it might be this Can't connect to Windows Azure Database (even though the MSDN documentation says the firewall is automatically configured). However I can connect with SQL Server Management Studio over port 1433 fine. I can of course open SQL Server Object Explorer and do Add SQL Server and add the connection string in there, and browse the tables etc in the same way, but I was just under the impression they should appear automatically under Windows Azure.