Search Engine: Elastic

Article ID: 129699, created on Oct 26, 2016, last review on Oct 26, 2016

  • Applies to:
  • Operations Automation 7.0


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:

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
[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)


The MS SQL server running Azure DB is not accessible by the Azure endpoint.


  • 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

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF