Skip to main content

Connecting SQL Server on Azure VM

Steps for configuring SQL Server connectivity in an Azure VM
The connection path is summarized by the following diagram:


Create a TCP endpoint for the virtual machine

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.
1.      On the Azure Portal, select Virtual machines (classic).
2.      Then select you SQL Server virtual machine.
3.     Select Endpoints, and then click the Add button at the top of the Endpoints blade.

4.      On the Add Endpoint blade, provide a Name such as SQLEndpoint.
5.      Select TCP for the Protocol.
6.      For Public port, specify a port number such as 57500.
7.      For Private port, specify SQL Server's listening port, which defaults to 1433.
8.      Click Ok to create the endpoint.

Configure a Network Security Group inbound rule for the VM

If you want to be able to connect to SQL Server over the internet, you have to configure an inbound rule on the Network Security Group for the port that your SQL Server instance is listening. By default, this is TCP port 1433.
1.      In the portal, select Virtual machines, and then select your SQL Server VM.
2.     Then select the Nework interfaces.

3.      Then select the Network Interface for your VM.
4.     Click the Network security group link.

5.      In the properties of the Network Security Group, expand Inbound security rules.
6.      Click the Add button.
7.      Provide a Name of "SQLServerPublicTraffic".
8.      Change Protocol to TCP.
9.      Specify a Destination port range of 1433 (or the port that your SQL Server Instance is listening on).
10.  Verify that Action is set to Allow. The security rule dialog should look similar to the following screenshot.

11.  Click OK to save the rule for your VM.
NOTE – If after these settings you are not able to access the VM through SSMS then please check whether Static IP is been set on the VM.
  

Comments

Post a Comment

Popular posts from this blog

SQL Code Review-Tips

General Standards: (Code Format, Naming Conventions, Datatype and Data Length, Syntax): §   Always follow a template in designing stored procedure so that it can easier developer job while designing and integrating. For example each stored procedure should be defined as various blocks such as “Comments Section”, “Variable Declaration”, “Actual Body”, “Audit”, ”Exception Handling”, “Temp_Obj_Removel” and define environment sections if any required. §   Check proper comments are used or not. Always describe procedure, inputs and expected output in comments section. §   Check naming conventions are used properly for procedure name, variables and other internal objects. §   Check all objects used inside the procedure are prefixed with the schema name and column names are referencing with table alias. §   Check all table columns used / mapped are using the correct datatypes and column length. §   Check if all required SET based options enable...
Post a Comment
Read more

Random Forest Introduction

Random Forest Introduction Random forest is one of popular algorithm which is used for classification and regression as an ensemble learning. It means random forest includes multiple decision trees which the average of the result of each decision tree would be the final outcome for random forest. There are some drawbacks in decision tree such as over fitting on training set which causes high variance, although it was solved in random forest by the aid of Bagging (Bootstrap Aggregating). Now firstly it is better to pay attention to decision tree algorithm and then study about random forest. Because random forest is divided to multitude decision tree. Decision Tree: Decision tree uses tree-like graph to take as best as possible decision by considering all elements of graph. For instance, remember tennis player who has agenda to play in different weather conditions. And now we want to know if player will play on 15th day or not? Finding Pure Branch There are 15 days which in...
Post a Comment
Read more