Unable to Add user to SQL Error While Installing eConnect Microsoft Dynamics GP 2010

Problem

When trying to install eConnect for Microsoft Dynamics GP 2010 on a new Windows 7 machine, you might encounter an Unable to Add user to SQL error. I tried to fix the problem by using many combinations of local/SQL Server credentials during the eConnect installation process, but was unable to get past this error.

 

Solution

To get past the error I had to create a brand new Windows 7 user. I then had to use the new user when installing eConnect. It seems that the eConnect installation process is trying to setup SQL Server login information for the supplied user and has trouble if they already exist in SQL Server.

 

Hope this helps someone.