Error: Database User Is Not Properly Configured for HVA Updates (F_JD22C1)

Issue

Setup tests fail. The following error appears:

Database user is not properly configured for HVA updates. F_JD22C1: Unexpected datatype '0' encountered for column <column_number> of table <table_number> while binding sqlserver output data.

Environment

Connector: High-Volume Agent SQL Server

Resolution

To resolve this issue, you must create a dedicated SQL Server database user for Fivetran's exclusive use. If you have already created a dedicated database user, ensure it is configured correctly. See the Create user step of our setup guide for more information.

Cause

This issue occurs when a dedicated SQL Server database user has not been created for Fivetran's exclusive use or has not been configured correctly.