Quickly test connectivity from Azure Website to SQL DB
In case you have an Azure Website and you need to confirm that your website can reach SQL Database service here is a quick and simple way to test it:
1) navigate to Kudu (it can be accessed at https://{yourwebsitename}.scm.azurewebsites.net )
(Kudu is the engine behind git/hg deployments, WebJobs, and various other features in Azure Web Sites)
2) open CMD that it’s located under ‘Debug console’ menu
3) run tcpping against your server using: tcpping {servername} .database.windows.net:1433
you will see something like this:
If you don’t see successful attempts something is wrong, please open a new support request so we can help you.