question

AnashwarN-4785 avatar image
0 Votes"
AnashwarN-4785 asked AnashwarN-4785 commented

How do I see which IP address are connecting to Azure sql database

How do I see which IP address are connecting to Azure sql database

I have set Allow Azure services and resources to access this server option as YES

and I want to track which IP address and connecting to my Azure SQL database

azure-sql-database
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.

1 Answer

KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered AnashwarN-4785 commented

@AnashwarN-4785 Thank you for reaching out.

To log incoming connections, you will first need to enable auditing on your database.
Then you can use log analytics to query for IP addresses of clients connecting to the database.
This article has the instructions.

Please let us know if you have further questions.


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

· 1
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.

Thanks ,will enabling auditing and check

0 Votes 0 ·