Unable to bootstrap commerce engine

Question

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 -

http://habitat.commerceengine.dev.local:5000/commerceops/Bootstrap()

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" }

Answer 1

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.