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

News Knowledge Base
1

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:

2.jpg
1.jpg

Root Cause: This error occurs when SQL user has windows authentication to access DB but configured to use SQL server authentication in connection string.


Resolution:

  • 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.