Metrics advisor connection to azure sql server

robert mcalpine 26 Reputation points
2022-02-03T11:02:33.13+00:00

Hi Guys,

I have started up a basic azure sql server and database. i can connect to it via the query editor and create tables, and push dummy datasets in.

When i want to connect to the sql database and source via azure metrics advisor, it does not allow me to connect with the basic connection string settings when i select Azure SQL Database | SQL server.

My MetricsAdvor Service stats up and works fine, I can connect to my SQL server and database and insert data. but i get a connection Failure. Please review paramaters error when i try to connect to the sql server via metricsadvisor.

My Connection String:
Server=servername.database.windows.net;Database=dbname;User Id=xxxxxxxxxxxxxxxxxxx;Password=xxxxxxxxxxxxxxxxxxxxx;

Question:
I see on top there is a prompt to please grant access the IP Address (list of 3 addresses ) in your data source. Is this needed for the connection to work ?

Azure SQL Database
Azure AI Metrics Advisor
Azure AI Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
80 questions
Azure AI services
Azure AI services
A group of Azure services, SDKs, and APIs designed to make apps more intelligent, engaging, and discoverable.
2,356 questions
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,806 Reputation points MVP
    2022-02-03T12:04:23.277+00:00

    Please set the encryption=yes on the connection string.

    When you create a new server in Azure SQL Database a server-level firewall blocks all access to the public endpoint for the server (which is accessible at mysqlserver.database.windows.net). You can create a firewall rule using the Azure portal to allow specific IP addresses to access the database server or databases as explained here. Make sure to set "On" the button named "Allow Azure services and resources to access this server" as you can see in the same documentation.

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful