Not able to connect to SQL DB from AZURE PORTAL

Singh, Amardeep (ANBAN) 1 Reputation point
2020-07-18T08:51:22.46+00:00

not able to connect to SQL DB from azure portal as well as management studio . pipelines based on this db are not executing . 12893-sql-db-error.png

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Kasun Rajapakse 431 Reputation points
    2020-07-19T07:42:30.94+00:00

    Hey,

    Can you try with SQL Management Studio too, before accessing SQL Management Studio make sure to whitelist the IP of the PC you're accessing through Azure SQL firewall rules.

    0 comments No comments

  2. Anurag Sharma 17,606 Reputation points
    2020-07-20T07:32:09.94+00:00

    Hi @Singh, Amardeep (ANBAN) , apologies you faced the issue and glad it is working now.

    There are couple of things you can do to understand the nature of issue in these type of scenarios:

    1. Check the health of the resource to understand if there is any event that happened. Refer to Link

    12962-image.png

    1. Check the service health of the subscription to know any outages, resilience and Azure Service Health. Refer to Link, it has a video tutorial to understand it more.

    12947-image.png

    ----------

    If an Answer is helpful, please “Accept Answer” or Up-Vote for the same which might be beneficial to other community members reading 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.