This post is part of the series on Implementing SmartConnect, an integration tool from eOne Solutions, which can take data from any source and integrate it into Microsoft Dynamics GP (and other systems such as Microsoft Dynamics CRM or Sales Force amongst others). It has a drag and drop interface to make creating integrations quick and easy for all users rather than just developers (as many integration tools target).
Once the core of SmartConnect has been installed, there are a few steps which need to be completed. The first of these is to configure the eOne SmartConnect Service to start with Windows. In theory it is configured to do so during the installation, but I’ve found that the service tries to start before SQL Server, but fails. This service needs to be running to allow maps to be scheduled to run automatically.
To remedy this problem, you have two options:
- Configure the service startup to Automatic (Delayed Start).
- Add a dependency for Microsoft SQL Server to the service.
Either one of these options, should be sufficient to remedy the issue and allow the service to correctly start and therefore allow maps to be scheduled.