How do I resolve the error "an error occurred creating the pass-through sql connection" Microsoft Dynamics GP?
Overview
You are attempting to download or update your customer card/list but the process is running really slowly and then the error "an error occurred creating the pass-through sql connection" appears, you want to know how to resolve the error.
Environment
Dynamics GP
Resolution
- Review the SQL log to confirm the cause and contact your IT or GP support for assistance if needed
- Make sure you're logged in as the Server admin (not a user with admin permissions)
* Run GP as a windows admin (Right click and choose Run as windows Administrator)
* Log in as SA- Keep in mind you can also update the tax schedule using SQL commands