Adding client IP to SQL Server firewall from a no open internet machine

Question

Hi Team,

1. I have a requirement where after creating an Azure SQL Database, under Azure SQL Server -> Networking, I need to add the client IP into firewall.

    I am working on a machine which does not have access to open internet,    as per my understanding the client IP address that gets added is a public one    (and not the one which we get through CMD->ipconfig).
   

In above case will client IP addition functionality work? If yes, which IP address will get added to firewall?

2. Is it possible to create an Azure SQL Server on Azure portal. without creating an Azure SQL Database, if yes, please mention how?

Thanks,

Salil

Answer 1

Hi @salilsingh-9961

To answer your First question-

To access Azure SQL Database from a machine that does not have access to the open internet, you can use Azure Private Link. Azure Private Link allows you to access Azure services (such as Azure SQL Database) over a private endpoint within your virtual network. This means that your traffic stays within the Azure network and does not go over the public internet.

Here is detailed document for your reference - https://learn.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview?view=azuresql

To answer your Second question- It seems you would like to create an empty logical Azure SQL Server. I believe you can create that.

Seach for "SQL Server" in the search bar and create a logical server.

Hope this helps!

Thank you.