Menu
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.
222
On your SQL database Overview page in the Azure portal, select Query editor (preview) from the left menu. On the sign-in screen, provide credentials to connect to the database. You can connect using SQL authentication or Azure AD.
Open your project in Visual Studio. In Solution Explorer, right-click the Connected Services node, and, from the context menu, select Add Connected Service. In the Connected Services tab, select the + icon for Service Dependencies. In the Add Dependency page, select Azure SQL Database.
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.
85
After right-clicking on Windows Azure, click on the Certificates Tab. There will be a link that says something like download certificate - sorry I can’t remember the exact wording. After clicking on this link, a browser should open up allowing you to download and save the certificate. Then go back to VS and import that certificate.
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
