Unable to Modify Queries
Company: KH Industries
Product Version: 184.108.40.206
Subject: Real time maps from GP to CRM 2013 not triggering
I had to rebuild the SQL server. Since then the RT maps from GP to CRM are not working but the RT maps from CRM to GP are. The bulk maps are working and the connection validates but if I click on Datasource Modify there is a long wait and then this:
It looks like a permission issue on the SQL server possibly but I have uninstalled and reinstalled SmartConnect multiple times with the same result.
the user which is starting the SmartConnect web service needs to be a user on the SQL server.
Yes, the Smartconnect web service app pool identity has a SQL Login, is sysadmin on the server, and is user mapped to the Smartconnect, Dynamics and company databases as db_owner with default schema of dbo. The maps are setup to run as the sa user.
If you would like to submit an answer or comment, please sign in to the eOne portal.