In order to access SQL Server from the internet, the virtual machine must have an endpoint to listen for incoming TCP communication. This Azure configuration step, directs incoming TCP port traffic to a TCP port that is accessible to the virtual machine.
Note
If you are connecting within the same cloud service or virtual network, you do not have to create a publically accessible endpoint. In that case, you could continue to the next step. For more information, see Connection Scenarios.
-
On the Azure Portal, select Virtual machines (classic).
-
Then select you SQL Server virtual machine.
-
Select Endpoints, and then click the Add button at the top of the Endpoints blade.
-
On the Add Endpoint blade, provide a Name such as SQLEndpoint.
-
Select TCP for the Protocol.
-
For Public port, specify a port number such as 57500.
-
For Private port, specify SQL Server's listening port, which defaults to 1433.
-
Click Ok to create the endpoint.
