Orchestrator is throwing 500 error and in Event Viewer, below errors are reported. System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'BMSHQ\RPA'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString
Login failed for user ‘BMSHQ\RPA’. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: <local machine>]
Root Cause: This error occurs when SQL user has windows authentication to access DB but configured to use SQL server authentication in connection string.
- Update the connection string in UiPath.orchestrator.dll.config and relevant AppSetting.Production.json to use windows authentication and update the application pool to run under service account having DB access.