We are trying to setup Sitecore commerce 8.2.1 update 2. The database is on a remote server.

The windows login is with a user SitecoreServiceswho is an administrator. The same user is also added to SQL Server.

When running the setup for CommerceServer.exe, the option selected is Windows Authentication and on clicking 'Test`, it says - successfully connected to database.

The Commerce Server installation went fine.

When trying to run the bootstrap by this URL -


there are a no. of error logs in the page and all of them show the same reason:

Login failed. The login is from an untrusted domain and   
cannot be used with Windows authentication  

For the database server also, I have created the SitecoreServices login with administrator privileges

{ "MessageDate":"2018-06-13T12:56:34.4378692Z","Code":"Error","Text":"SQL:block:findentity.Exception: SQL.GetEntityCommand.Exception: Id=Entity-CommerceEnvironment-CommerceOps|Environment=GlobalEnvironment|Message='Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.'|Number=18452|Procedure=''|Line=65536","CommerceTermKey":"SQL:block:findentity" }

  • How your connection string to SQL server looks like in Sitecore Commerce engine json? Commented Jun 14, 2018 at 3:56
  • Check the app pool user identity of commerce engine instance where bootstrap is done. And see if it’s the same user as the one setup with permissions in sql
    – Praveen
    Commented Jun 18, 2018 at 10:11

2 Answers 2


If your database is on a remote server and you are not using a Domain/Active Directory user, you need to setup your Commerce Engine to use SQL Authentication instead. You can change that by going to CommerceEngine\wwwroot\bootstrap\Global.json, under EntityStoreSqlPolicy set TrustedConnection to false, supply the SQL user username and password.

  • After adding in all the 4 global.json files also, this error is not resolved. Do I have to change it in any other config file ? @rameez Commented Jun 17, 2019 at 5:56
  • This did not help Commented Aug 21, 2020 at 16:28

I got the same error while trying to install Sitecore Commerce 9.2 in local machine.

  1. add IP address and system name to host file.
  2. add the account/username to “Access this computer from the network” local security policy (secpol.msc) Then it got resolved.

For more details check here https://sitecore-commerce.blogspot.com/2020/10/login-failed-login-is-from-untrusted.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.