Unable to add user to SQL when installing eConnect

Use solution 1 if you are installing econnect for the first time.

This issue happens if the user you are entering on the installation does not have DYNGRP role assigned to them for every GP database.

Go to SQL>>Security>>Logins
Add the user, give them sysadmin role
Give them access to the GP databases and also assign the DYNGRP role to each GP database.


Use Solution 2 if you are installing econnect on another machine or reinstalling.

During the eConnect Install
Mark/Tick the box 'Do not add service user to SQL' in the SQL Connection Information window.
This will prevent SQL from trying to re-add the user which gives the error that it cannot add the user.