First, we review the previous chapters:
1. First we created a new virtual Machine with SQL Server 2012 installed.
2. After the creation, we mount disk in this VM, the F disk (50GB) and the G disk (80GB).
3. Then we configure SQL Server 2012 to Data,log, backups to the F disk and G disk we created respectively. The TCP/IP protocol is set to Enabled and firewall rules are configured to allow access to port 1433.
In this chapter I will show you how to set up the VM endpoint. In this way, we can connect directly to the SQL Server service created by the cloud through our local SQL Server Management Studio.
First let's talk about the endpoints concept of Windows Azure. Windows Azure Endpoints is divided into two types, namely public port and private port.
Public Port. Indicates that the endpoint is open to the Internet. All externally initiated access is done through the public port.
Private Port. This endpoint is not open to inetnet and is open only to Windows Azure. If Windows Azure contains multiple instances (multi instance) parallel computations, internal access to instances and instances (instance to instance) is implemented through private port.
Endpoint uses TCP or UDP protocols, and TCP protocols include HTTP and HTTPS traffic.
Let's take a look at the following picture:
In the figure above, the public port is the 57500,private port is 1433.
When an external resource wants to access the Windows Azure Service, it is accessed through the port number for 57500来.
Windows Azure's load balance then forwards the request to an internal 1433-port number to achieve access.
The advantage is that Private port enables internal messaging to be communicated to each other. Public port can open the Internet to Windows Azure access. There is no conflict between the two. And in multiple instances, the message of public port can be routed to each VM through load balancing to achieve the automatic load balancing of the request. The specific architecture is as follows:
See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Servers/cloud-computing/