We are currently in the process of implementing Microsoft Dynamics for Finance and Operations (on-premises). The ERP system is deployed in a separate domain from the primary domain used for other services such as email etc, however there are trusts between the two domains. User machines a registered on the primary domain. One can access the D365 application via web using either credentials from the primary domain or the ERP domain. My challenge comes with the excel add-in. I managed to make it work in the previous months just by installing a certificate in the primary domain. However, starting from last week the add-in is failing to authenticate users. Below are screenshots of the errors I am getting.
Debugger:
Access to XMLHttpRequest at 'https://<D365 URL>/namespaces/AXSF/OfficeApps/Public/ServerConfiguration?_=*************' from origin 'az689774.vo.msecnd.net' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.
ajax.ts:157 GET https://<D365 URL>/namespaces/AXSF/OfficeApps/Public/ServerConfiguration?_=**************** net::ERR_FAILED
excel-win32-16.01.js:26 Warning: Office.js is loaded outside of Office client
Event Viewer:
Encountered error during OAuth authorization request.
Additional Data
Exception details:
Microsoft.IdentityServer.RequestFailedException: MSIS9230: Failed to authenticate the user as the request does not contain any authentication credentials.
at Microsoft.IdentityServer.Web.Protocols.OAuth.OAuthAuthorization.OAuthAuthorizationProtocolHandler.SignIn(OAuthAuthorizationRequestContext authorizationContext, SecurityToken securityToken, SecurityToken deviceSecurityToken, Boolean& ssoSignInAttempted)
May you kindly assist with a way out of this? I am using Excel for Office 365 and I am on the latest build.
