Skip to main content
covid-19 thumb.png
Learn more about federal and state actions related to the COVID-19 outbreak with our guide to coronavirus tax relief.
Avalara Help Center

How do I resolve the error "an error occurred creating the pass-through sql connection" Microsoft Dynamics GP?

  1. Last updated
  2. Save as PDF

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