I followed the steps that you suggested and am now getting a different error message, please see below. I have cross checked the Azure SQL server name and DB name multiple times and tried a few times to refresh and connect however get his same error.
{
"error": {
"code": 502,
"source": "europe-001.azure-apim.net",
"clientRequestId": "25868f8c-6128-448f-8209-2436c3a53b42",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Unexpected Exception : Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: h. Path '', line 0, position 0.\r\n at Newtonsoft.Json.JsonTextReader.ParseValue()\r\n at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)\r\n at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)\r\n at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)\r\n at Microsoft.Azure.Connectors.Common.Profile.TokenHeaderInformation.GetProperty[T](String key) in X:\\bt\\1024456\\repo\\src\\source\\common\\Profile\\TokenHeaderInformation.cs:line 81\r\n inner exception: Unexpected character encountered while parsing value: h. Path '', line 0, position 0.\r\nclientRequestId: 25868f8c-6128-448f-8209-2436c3a53b42",
"error": {
"message": "Unexpected Exception : Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: h. Path '', line 0, position 0.\r\n at Newtonsoft.Json.JsonTextReader.ParseValue()\r\n at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)\r\n at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)\r\n at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)\r\n at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)\r\n at Microsoft.Azure.Connectors.Common.Profile.TokenHeaderInformation.GetProperty[T](String key) in X:\\bt\\1024456\\repo\\src\\source\\common\\Profile\\TokenHeaderInformation.cs:line 81\r\n inner exception: Unexpected character encountered while parsing value: h. Path '', line 0, position 0."
},
"source": "sql-ne.azconn-ne.p.azurewebsites.net"
}
}
}
