Microsoft Data SqlClient SqlException 0x80131904 Login Failed : The Login Is From An Untrusted Domain And Cannot Be Used With Integrated Authentication

News Knowledge Base
1

How to resolve the error "Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication" ?

Issue description

Sometimes, Orchestrator may become inaccessible with a 500 error and subsequently, the following exception in the application event viewer logs --> "A 500 error is thrown on Orchestrator and "Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication." See below for example:

image.png

Resolution

  • If the SQL server is on a different machine than the Orchestrator server machine, check the user under which apppools are running on IIS. This needs to be a Domain account. If a local account is used here, it cannot access the DB on the SQL server.
  • If the above doesn't work, check the Connection String in the "UiPath.Orchestrator.dll.config". If it is using Windows authentication, ensure the SQL server is configured to use both Windows and SQL Server Authentication. Read more here: