Page History

Setting up SQL Server Database Permissions

When the Connector runs in two server mode, the eConnect COM+ application uses SQL Server integrated security to connect to the eConnect business objects. During the installation of eConnect, you need to supply a domain user account for the COM+ application. This domain user account need be put in the DYNGRP in SQL Server. To set up the user account, complete the following procedure:

1. Launch "SQL Server Enterprise Manager" and go to the DYNAMICS database.
2. Right click User under the database DYNAMICS and choose New Database User.
3. Add the domain user account to the DYNGRP database role.

1. What are the pre-requisite software requirement for DBSync integration with Microsoft Dynamics GP?

The eConnect libraries must be installed (eConnect Documentation) however the full eConnect Runtime module does not need to be installed.

2. Does DBSync need to be installed on the same machine as that of Microsoft Dynamcs GP?

DBSync Microsoft Dynamics GP adapter can be either configured on the same instance GP is installed or on a remote machine which can access GP database.

3. What are the limitations of DBSync integration with Microsoft Dynamics GP?

The eConnect interfaces do not support every object and interaction available within Microsoft Dynamics GP. If your integration scenario requires working with objects from other modules or more sophisticated queries, you will need to use our Database Adapter for Microsoft SQL Server to connect to backend database tables directly. While this is an option, it is recommended to avoid accessing Microsoft Dynamics GP database directly to maintain data integrity and business rule executions.