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;

You

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.

What should we write about next?

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

(Visited 779 times, 1 visits today)

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

Leave a Reply

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