In the last post in this series, I installed the Connector Service; as part of the installation a database was created and populated with the required tables. The service account is granted access to these tables, but also needs to be granted the DYNGRP role in the Microsoft Dynamics GP system and company databases as well.
You can do this via SQL Server Management Studio. Expand Security and Logins, find the service account, right-click and select Properties.
Select User Mapping and the the system database (which in my example is called D18R2.
In the Database role membership… section, mark the checkbox next to DYNGRP:
Repeat this action for the company databases and then click OK to commit the changes.
This action is only required to be done for the Domain account which will run the connector service as this service handles all connections to the database, including those from the Dynamics GP client.