question

OliverV-2772 avatar image
0 Votes"
OliverV-2772 asked CarrinWu-MSFT commented

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

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-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @OliverV-2772, welcome to Microsoft Q&A! Is there has an error message for this issue? Here have steps about how to Set up SQL Server TDE Extensible Key Management by using Azure Key Vault which you can refer to.

0 Votes 0 ·

Hi @OliverV-2772, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
OliverV-2772 avatar image
0 Votes"
OliverV-2772 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @OliverV-2772,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.