Sometimes when connection to Azure SQL DB fails and you want to test the network layer to confirm this is not network issue that prevents you from accessing your Azure DB service.
For Azure SQL DB use port 1433
Using PowerShell (Recommended)
Use the following command to confirm you have true for the TcpTestSucceeded
Test-NetConnection <YourServerName>.database.windows.net -Port <TCPPort>
Using PsPing
Download the PsPing tool.
psping <YourServerName>.database.windows.net:<TCPPort>
Further check Azure SQL Connectivity settings reference link: https://docs.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings
No comments:
Post a Comment