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 "String or binary data would be truncated. The statement has been terminated." in Sage 500?

  1. Last updated
  2. Save as PDF

Overview

You are trying to validate your credentials in the AvaTax Setup configuration but receive "String or binary data would be truncated. The statement has been terminated."

Environment

Sage 500

Resolution

  • Make sure all Sage 500 users are logged out of Sage 500 and that Sage 500 is closed.
  • Uninstall AvaTax on the Server
  • Reinstall AvaTax on the Server
  • Re-enter credentials and validate

Note: You must install AvaTax for Sage 500 on your Sage 500 server and on the workstation of every Sage 500 user who needs to use AvaTax.

Next steps 

For more information, see Sage 500