Skip to content


How to update to SmartConnect

The following are the steps to follow when upgrading to the SmartConnect This version of SmartConnect only works on Great Plains Dynamics 9.0

1. Make sure all users are logged out of GP.
2. Backup the Dynamics GP Databases, all company databases and the Dynamics database.
3. Make a note of the settings in the SmartConnect Setup window Tools – SmartConnect – Setup.
4. Uninstall eOne SmartConnect from Add\Remove programs in control panel.
5. Remove the SmartConnect Web services website, if you have it installed and remove the old web site as well as old assemblies from C:\WINDOWS\Assembly
6. Download the latest SmartConnect Installer from the eOne website.
7. Run the SmartConnect Installer executable and install SmartConnect.
8. Delete the dictionary SMRTCONN.DIC from C:\Program Files\Microsoft Dynamics\GP, after the upgrade the new dictionary SMRTCONN9.dic will be installed in this directory
9. Edit Smart Connect dictionary version to read SMRTCONN9.DIC in Dynamics.set file in the above directory
10. Launch Dynamics GP and include the new chunk.
11. Log in to Dynamics GP as sa.
12. Click Finish installing Smart Connect
13. Go to Tools – SmartConnect – Setup and make sure all the settings are as they were before upgrading (also MS CRM Settings).
14. Go to Tools – SmartConnect – System Maintenance to perform system update after the install.
15. De-register Real Time Triggers and Create GP Resource Cache options should be checked and hit process button
16. Re-register all the maps you have that are built off a CRM Real-Time (Plug-in) data source.
17. After installing the new web service verify that the impersonation user on the virtual directory is set to a user with admin rights and has been linked to a GP user.
18. On the IIS server check that the installer has registered the following dlls in C:\WINDOWS\Assembly: eOneSmartConnect.CRM v eOne.SmartConnect.Engine v10.0.38 eOne.SmartConnect.QueryBuilder v10.0.0.38
19. Perform an iisreset from the command prompt 20. Test all your current maps.


Creating an Integration in
eConnect error - Login failed for user
32 bit Excel Add-in for SmartConnect 21 does not appear after installing.
Connection could not be validated when using Excel data source
Salesforce Error: Unable to create/update fields check security settings


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.