The port on the backend VM is mentioned incorrectly, I think.

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure

https://docs.microsoft.com/azure

Creative Commons Attribution 4.0 International

10.26k stars 21.44k forks source link

The port on the backend VM is mentioned incorrectly, I think. #81151

Closed Peeyush-Now closed 3 years ago

Peeyush-Now commented 3 years ago

The port on the backend VM is mentioned incorrectly in case there are more than 1 SQL Servers, I think. The Fronend port is 1434 but the backend port should still be 1433 in the pink Note section.

I would suggest the frontend ports to be 14331, 14332, and so on.. and the backend is still 1433 or the configured port for the db.

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

ID: 0ad13676-0e4b-6e1d-bd9c-e7b6e6698da9
Version Independent ID: 37f5f9b3-c78e-78ff-7d94-ea70c2958ed7
Content: Access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint - Azure Data Factory
Content Source: articles/data-factory/tutorial-managed-virtual-network-on-premise-sql-server.md
Service: data-factory
GitHub Login: @lrtoyou1223
Microsoft Alias: lle

Svijay-msft commented 3 years ago

Thanks for the question! We are looking into this and will get back to you soon.

Svijay-msft commented 3 years ago

Hello @Peeyush-Now

I am assuming that you are talking about the below note section.

As per the documentation here ,

If you look at the below command for SQL Sever 2 :

sudo ./ip_fwd.sh -i eth0 -f 1434 -a <FQDN/IP> -b 1433

If my understanding is correct, the requests/packets received are being forwarded to the destination SQL Server 2 at Port 1433.

Peeyush-Now commented 3 years ago

Consider a scenario where Azure Data Factory is being configured to collect data from 2 or more on premise SQL Servers, each of them running on the default port 1433. The load balancer knows by FQDN/IP which sql server to route to, but needs a different port for routing to the backend pool VMs. The backend VMs use the routing table port to then decide which FQDN to forward the request to. Have I undersood this right?

So may be your documentation is correct, and for clarity, it can ADF request (sql server 1:1433) --> load balancer:443 --> backend vm<1.. n>:14331 -->sql server1:1433 ADF request (sql server 2:1433) --> load balancer:443--> backend vm<1.. n>:14332-->sql server2:1433 .. ADF request (sql server X:1433) --> load balancer:443--> backend vm<1.. n>:1433X-->sql serverX:1433

If you agree, please close the issue else let me know.

Svijay-msft commented 3 years ago

Yes, That's right. The backend VM forwards the request to the respective SQL Server on port 1433 based on the routing table port of the VM.

We will close this out, but if you feel you need more information please just let us know.