Symptoms
When click CCP > Microsoft Azure it is loading for few minutes and then displays:
Unknown error
In browser debug console the following request results in error:
https://cp.example.com/aps/2/resources/842dc490-986c-4492-886e-df7532894e3d/consumption?locale=en-US
The returned error
500 internal server error
{
"error": "unknown",
"message": "An unexpected error has occurred.",
"category": "unknown",
"context": null,
"packageId": "ef5edbcc-e48f-4c48-be2f-9e6d01b961bd"
}
On Azure endpoint the log file application-log.txt contains the following entries:
[2016-10-26 11:38:09.1927 557b4ac0-3bb6-42a8-ae6b-2b20e22c7a80 8 DEBUG] <App> Incoming request: GET https://10.0.0.15/aps/tenants/842dc490-986c-4492-886e-df7532894e3d/consumption?locale=en-US
...
[2016-10-26 11:38:58.7580 557b4ac0-3bb6-42a8-ae6b-2b20e22c7a80 9 ERROR] TenantsController.GetConsumption finished by exception System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Cause
The MS SQL server running Azure DB is not accessible by the Azure endpoint.
Resolution
- Check if the database host is running
- Make sure any firewall settings do not block connections from the Azure endpoint to Azure database server
- Make sure MS SQL server running on the database server has TCP/IP protocol enabled