Sometimes when users attempt to login, an “A get/change on operation table ‘SY_Pathnames’ failed accessing SQL data” error message pops up as seen below.

Personal Data Keeper SQL Data

When you click on more info, the following error code is shown.


Here’s how you can solve this:

1) Edit your ODBC settings

  • Click on Data Sources (ODBC), and click on the System DSN tab: to select the ODBC for PDK, and click on Configure
ODBC Data Source

2) In the Microsoft SQL Server DSN Configuration window.

  • Confirm that you are connecting to the correct SQL server and click next
Microsoft SQL Server DSN Configuration

3) Mark the checkbox : “Change the default database to” 

Microsoft SQL Server Default

4) Change the name of the database to ‘DYNAMICS’ in the field for Change the default database to (Note: Both of the checkboxes for the “Use ANSI…” settings should not be marked.)

Microsoft SQL Server Change Default

5) Click Next and Finish.

And there you go! The error will now be resolved and you will be able to log in.

Need GP help? Get worry free Dynamics GP Upgrades and support from the experts at MIBAR. Contact us for more information. Or learn more about Dynamics GP alternatives.

As a Dynamics GP user, it is important that you understand GP End of Life. It is not just a distant event; it carries substantial implications that every business must be aware of. To learn more, please watch our on-demand webinar, Microsoft Dynamics GP End of Life – What’s Next, to:

  • Gain a firm grasp of the critical dates that will shape your decision-making process.
  • Decode the terminology to understand how it will directly affect your day-to-day operations & future of your org.
  • Delve into the security & business continuity risks that may jeopardize your organization.

Click here to watch now.

Dynamics GP Alternatives

Additional Microsoft Dynamics GP Resources

Reconcile Misaligned Receivables Batch in Microsoft Dynamics GP

Enter, Process and Reconcile Credit Card Transactions in Microsoft Dynamics GP

Voiding Historical Credit Memos in Microsoft Dynamics GP

Expedite Checkbook Register Inquiries in Dynamics GP with Date Restrictions