Database Login Failed From Azure App Service

News Knowledge Base
1

Orchestrator 500 Internal server error

Error Description:

Routing Destination:uipathdb.westeurope1-a.worker.database.windows.net,11001

Microsoft.Data.SqlClient.SqlException: Login failed for user 'sa-admin'.

at void Microsoft.Data.ProviderBase.DbConnectionPool.CheckPoolBlockingPeriod(Exception e)

at DbConnectionInternal Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectio

Troubleshooting Steps:

If using Azure App Server deployment, execute the below comment from the app server cmd.

  • tcpping <SqlServerName>:portnumber

  1. Check if possible to get the response. If not then work with the DB team to resolve this issue. This error indicates App Server is unable to establish the connection into the database.
  2. If able to get the response, then execute the below comment
  • sqlcmd.exe -S <SqlServerName>,1433 -d <SqlDatabaseName> -U <userName> -P <password> -Q "select * from sys.tables"

Check if able to login via the cmd from Azure app server portal, if not then this issue from Azure app database side, work with the Azure support team to get it resolved.

How to open CMD from Azure App Service?

  1. Go to App service->Advanced Tools->Go->Debug Console->CMD