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