Excel add-in error could not load maps
Lewis asked 4 years ago
I’m setting up a new SmartConnect installation. I have the SmartConnect importing from the console successfully. I’m even able to browse to the SmarConnect WCF Service, without issue.. http://win12gp18:5557/smartconnect.svc
Now I want to configure the Excel add-in, and I’m receiving a message. “Could Not Validate Credentials, could not load maps. Verify credentials are correct and at least one map exists in SmartConnect.”
This looks simple, however I’m unable to figure out where the credentials are failing.
Now I want to configure the Excel add-in, and I’m receiving a message. “Could Not Validate Credentials, could not load maps. Verify credentials are correct and at least one map exists in SmartConnect.”
This looks simple, however I’m unable to figure out where the credentials are failing.
Answers
Lewis answered 4 years ago
Additional information I’m using an on premise connection to Dynamics GP 2018
Ethan Sorenson Staff answered 4 years ago
Lewis,
Connecting to the above URL in a browser does not require use of credentials. So the issue is most likely in IIS. Check the following settings.
*After making any changes restart the WCF service
If this doesn’t fix it, submit an email to support@eonesolutions.com
Connecting to the above URL in a browser does not require use of credentials. So the issue is most likely in IIS. Check the following settings.
- Check the Application pool for the SmartConnectWCF and verify the Identity is for a user that is setup as an admin in SmartConnect.
- Go to Sites > SmartConnectWcf > Authentication > and check that ASP.NET Impersonation is enabled and is using the same credentials as the Application Pool.
- Make sure the Windows Authentication is Disabled.
*After making any changes restart the WCF service
If this doesn’t fix it, submit an email to support@eonesolutions.com