SQL Azure

Azure and the Tools

IntelliDB Support in Azure
Many organisations have already been migrated to Microsoft Azure. Yet the others have been planning to migrate their infrastructures to Azure Cloud. The below referenced link will assist the new users.
Although many of the activities can be done via powershell,  SSMS and other tools can be handy tool for this.
Azure Portal:
New Portal – https://portal.azure.com/
Download SQL Server Management Studio (SSMS)
https://msdn.microsoft.com/library/mt238290.aspx  (This version of SSMS is free and does not require a SQL Server license to install and use)

Connection Issue and the solutions:


Windows Azure SQL Database (formerly known as SQL Azure) works exclusively and only on TCP port 1433. It only support SQL Server Authentication, TCP connection and TDS protocol as of today.
In order to successfully establish connection to SQL Azure one must fulfil the following requirements:
  • Create SQL Azure server & Database
  • Setup SQL Azure Server’s firewall rules to accept connections from the IP address of application that will connect to that server
  • Make sure the box (be it Virtual, or home, or whatever) has no blocking outbound TCP port 1433
  • Explicitly force encryption in connection string
  • Explicitly chose to not trust server certificate in connection string
Please note that many (if not all) ISPs (Internet Service Providers) and Hosters, as well as IT staff within companies DO block outgoing TCP Port 1433 due to the SQL Slammer worm. This outgoing port blocking appears to be one of the most faced issues of newcommers to SQL Azure.
UPDATE Nov. 2015
As of August 2015, there is preview feature that enables you to use Azure AD to authenticate to Azure SQL Database. You can read more on this new preview feature here:
Reference: http://stackoverflow.com/questions/11617687/cannot-connect-to-azure-sql-database-even-with-whitelisted-ip

Leave a Reply

Your email address will not be published. Required fields are marked *