How to Connect two Azure sql Db's without whitelisting ip's in firewall

Anonymous
2023-12-13T20:40:56.9166667+00:00

We have two Azure sql db's. We are currently granting access of db1 to db2 by whitelisting the ip address of db2 in db1's firewall. Due to dynamic nature of this ip sometimes we need to update the ip in the firewall. is there a way to connect these two db's without whitelisting of the ip's?

Azure SQL Database
0 comments No comments
{count} votes

Answer accepted by question author
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2023-12-13T23:17:47.5533333+00:00

    Hi @Baljit Singh (HCL TECHNOLOGIES CORPORATE SER) Welcome to Microsoft Q&A thanks for posting your question.

    You can use the Azure Private Link feature to connect the two databases securely and privately.

    follow the document here for more information https://learn.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview?view=azuresql

    Also, here I found a similar ask on SO forum https://stackoverflow.com/questions/74821726/how-to-connect-to-azure-sql-database-without-ip-whitelisting

    Regards

    Geetha


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.