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.
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
2) In the Microsoft SQL Server DSN Configuration window.
- Confirm that you are connecting to the correct SQL server and click next
3) Mark the checkbox : “Change the default database to”
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.)
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.
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
