Skip to main content
Avalara Help Center

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

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