Powershell script to enable Microsoft.SQL service endpoint and add to Azure SQL

Jeff Fazio 36

We have certain VM's that need to be able to access Azure SQL. Since allow public access is turned off, I need to add the Virtual Network/Subnet to SQL Instance. Then also, I need to enable Microsoft.SQL for the service endpoint on any of the subnets with the VM's.

Since this could get missed during the build process, I was thinking of creating an Automation that will check a few times a day to make sure all the subnets in a Virtual have the Microsoft.SQL service endpoint enabled. I have this part setup and works fine.

I guess is there a way in to create a script so that if Subnet A is in VirtualNetwork 1 then check to make sure Microsoft.SQL is enabled and it's been added to SQLServer Virtual Network list to be allowed. If not, then add it.

I think a problem is going to be that Automation can only be run on the subscription it's created in.

If anyone has any ideas, that would be great.

Rahul Podila 115 Reputation points Microsoft Vendor

2024-09-23T12:06:55.42+00:00

Hi @Jeff Fazio
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We need to ensure that the Microsoft.SQL Service endpoint is enabled for the subnet where your VMs reside. This endpoint provides a communication channel between your network and SQL Database.

We must confirm that the subnet includes networks allowed to access your SQL Server.

We will create a script that will automatically check each subnet to verify that the Microsoft.SQL service endpoint is enabled.

If the script detects that the endpoint is not active, it will activate it and check that the subnet is added to SQL Server's list of allowed networks

To detect and address any issues, we will schedule the scripts to run multiple times per day, so you won’t have to manually manage these updates.

If you have any further quires, do let us know

---------------------------------------------------------------------------------------------------------

If the answer is helpful, please click "Accept Answer" and "Upvote it".
Rahul Podila 115 Reputation points Microsoft Vendor

2024-09-25T06:23:24.4233333+00:00

Hi @Jeff Fazio If you had a chance to see my comment to your question. If it was helpful, please click "Upvote" on my post let us know Thank you...!
Rahul Podila 115 Reputation points Microsoft Vendor

2024-09-27T06:52:49.1666667+00:00

Hi @Jeff Fazio
If you had a chance to see my comment to your question. If it was helpful, please click "Upvote" on my post let us know Thank you...!

Share via

Powershell script to enable Microsoft.SQL service endpoint and add to Azure SQL

Your answer