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:

kudu_tcpping

 

If you don’t see successful attempts something is wrong, please open a new support request so we can help you.