SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
How to connect azure automation account to azure sql server which has private endpoint enabled
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 0%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yuvaraj Sonale
0
Reputation points
How to connect azure automation account to azure sql server which has private endpoint enabled
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi 80 Reputation points Microsoft Vendor2025-02-19T20:02:15.6366667+00:00 Hi @Yuvaraj Sonale ,
Thanks for the Question and using Microsoft Q&A platform.
As per my understanding your Question is, you want to connect azure automation account to azure sql server which has private endpoint enabled.
To connect an Azure Automation Account to an Azure SQL Server with a private endpoint enabled, you need to make sure that your Automation Account can access the SQL Server privately within the same Virtual Network (VNet) or through VNet peering.
Please fellow the below steps:
- Create a Virtual Network:
- Make sure the SQL Server has a private endpoint configured within a virtual network (VNet). This means the SQL server is accessible through its private IP address in that network.
- The Automation Account should either be in the same VNet or in a VNet that is peered with the VNet where the SQL Server's private endpoint resides.
- Create an Azure SQL Server and Private Endpoint:
- Set up an Azure SQL Server.
- Create a private endpoint for the SQL Server to enable private and secure communication.
- Configure Azure Automation Account:
- Use Azure Private Link to securely connect your Azure Automation account to the SQL Server.
- Ensure that the network traffic between the VMs on the virtual network and the Automation account traverses over the private link on the Microsoft backbone network.
- Use Azure Private Link to securely connect your Azure Automation account to the SQL Server.
- Test Connectivity:
- Verify the connectivity to the SQL Server private endpoint from the VM.
For detailed steps, you can refer to the Azure documentation and tutorial on connecting to an Azure SQL Server using a private endpoint. Additionally, you can find more information on using Azure Private Link with Azure Automation here.
If you have any specific questions or need further assistance, feel free to ask!
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
- Create a Virtual Network:
-
Mallaiah Sangi 80 Reputation points Microsoft Vendor
2025-02-20T20:08:31.1833333+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
Mallaiah Sangi 80 Reputation points Microsoft Vendor
2025-02-21T17:35:06.13+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer