Salesforce GP - Troubleshooting

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 needs to be put in the DYNGRP in SQL Server. To set up the user account, complete the following steps:

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 configured either on the same instance where GP is installed; or, it can be configured on a remote machine that 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 you avoid accessing Microsoft Dynamics GP database directly to maintain data integrity and business rule executions.