Error: Attempting To Log In From A Data Source Using A Trusted Connection

Microsoft Dynamics GPI’ve been building a test environment in a virtual machine the last few days to do a migration from Microsoft Dynamics GP 9 SP3 to 2010 R2.

After completing the upgrade I tried to log into GP and received the following error;


To fix this error nothing needs to be done to SQL Server. It’s basically the result of slight carelessness when creating the ODBC, whereby I left the authentication at Windows Authentiction. To correct the error, open the x86 ODBC Data Sources (%windir%\syswow64\odbcad32.exe), and configure the existing System DSN.

On the second page of the wizard, change the authentication type to “With SQL Server authentication using a login ID and password entered by the user.”;

Microsoft SQL Server DSN Configuration

Supply a valid username and password and progress through the rest of the wizard and save the changes. Once this has been done, you’ll be able to login to Microsoft Dynamics GP without receiving the error.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

3 thoughts on “Error: Attempting To Log In From A Data Source Using A Trusted Connection

  1. Amanda says:

    You are a life saver.

    Thank you so much

Leave a Reply

Your email address will not be published. Required fields are marked *