Login Failed For User Reason Attempting To Use An NT Account Name With SQL Server Authentication

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>]

Error Images:


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.