While connecting to a MS SQL Server database through the Microsoft Dynamics GP preconfigured adapter, there may be a requirement to interoperate with MS SQL Server’s Integrated Security feature. The following steps need to be followed in order for integration to work with the Integrated Security feature:
- Configure the Log On property of the Data Agent service to use a domain user (there must be a \ in the account name). The Password and Confirm Password fields should contain the password values for the configured domain user.
- In the Microsoft Dynamics GP adapter configuration in the Data Designer, enter \ in the Username field and welcome in the Password field. These values trigger integration to use the credentials entered in the data agent service’s ‘Log On’ credentials to connect to the MS SQL Server database. The values entered within the data designer will not be used to connect to the source database.