Ports and Sites needed for On Premise SQL to access Azure resources

OliverV 1 Reputation point
2021-04-09T12:09:59.4+00:00

Hello,

I am currently setting up TDE with On Premise SQL using Azure Key Vault, we wrote an application to accomplish this but it seems we need to open holes for the SQL Server connector to reach back out to Azure Key Vault. I am looking for the specific sites and or ports that I need to open for this to work.

Thanks,
Oliver

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,437 questions
{count} votes

2 answers

Sort by: Most helpful
  1. OliverV 1 Reputation point
    2021-04-12T12:34:58.747+00:00

    Hi Carrin,

    We basically get a timeout when the SQL box attempts to reach back out to Azure AD to get a token, everything else from Azure going down to SQL is working, would you have a site that lists all the urls that are needed to be open to firewalls to reach back out to Azure AD from an on premise server. I can then check with our network team to see if they missed anything.

    Thanks Oliver

    0 comments No comments

  2. CarrinWu-MSFT 6,891 Reputation points
    2021-04-13T02:35:28.087+00:00

    Hi @OliverV ,

    Please refer to Prerequisites for Azure AD Connect to get the details about the URLs. This is Troubleshoot SQL connectivity issues with Azure AD Connect might be help you to resolve this issue.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

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