What network config to hit azure sql in azure batch job

Tomahawk2 0

Running into issues where azure batch job can't hit sql server. Both are in the same subnet. What network configuration is required to allow the azure batch pool and sql azure database to communicate? I would assume the azure batch job that is just hitting the azure sql wouldn't be that complicated and would be allowed.

Prrudram-MSFT 24,561 Reputation points

2024-04-05T03:51:09.4466667+00:00

Hi @Tomahawk2

Is it Azure SQL DB(PaaS) or Azure SQL server DB?
Prrudram-MSFT 24,561 Reputation points

2024-04-10T08:02:46.9333333+00:00

Hello @Tomahawk2

Thank you for reaching out to the Microsoft Q&A platform.

If your Azure Batch pool and SQL Server database are in the same subnet, they should be able to communicate with each other by default. However, there are a few things you can check to make sure that the network configuration is set up correctly.

First, make sure that the SQL Server is configured to allow connections from the Azure Batch pool. You can do this by checking the firewall settings on the SQL Server. By default, SQL Server is configured to block all incoming connections except for those on the same machine.
You will need to add an exception to the firewall to allow connections from the Azure Batch pool. You can do this by adding an inbound rule to the firewall that allows traffic on port 1433 (the default port for SQL Server). Next, make sure that the Azure Batch pool is configured to use the correct network settings.
When you create a Batch pool, you can specify the virtual network and subnet that the pool should use. Make sure that the pool is configured to use the same virtual network and subnet as the SQL Server. Finally, make sure that the Azure Batch pool is configured to use the correct DNS settings. The pool should be configured to use the same DNS server as the SQL Server.
This will ensure that the pool can resolve the hostname of the SQL Server and establish a connection. If you have checked all of these settings and are still unable to connect to the SQL Server from the Azure Batch pool, you may want to check the logs on both the SQL Server and the Azure Batch pool to see if there are any error messages that can help you diagnose the issue.

I have answered this assuming that you are using SQL server on an azure VM.

I hope this helps you troubleshoot the issue. If you have any further questions or concerns, please let me know.
Anisio Wilian Fernandes Sodre 0 Reputation points

2024-08-08T20:04:34.4033333+00:00
Good afternoon, I hope you are well. How can I configure DNS on the batchaccount pool?

Share via

What network config to hit azure sql in azure batch job

Your answer