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 ''. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString

Login failed for user ’ '. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: ]

Issue description:
Orchestrator is throwing 500 error and in Event Viewer, the below errors are reported.
image.png
image.png


Root Cause:
This error occurs when an SQL user utilizes Windows authentication to access DB but it is 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 the service account having DB access.