Error: F_JD0A57 Failed To Retrieve Database Server Process Handle

Issue

Setup tests are passing, but the connector fails during its initial sync with the following error:

F_JD0A57: Failed to retrieve database server process handle: Access is denied.

Environment

Connector: HVA SQL Server

Resolution

To resolve this issue, ensure that the operating system user assigned to Fivetran has permission to read system files.

On Linux, provide the Fivetran user with read access to the .mdf and .ldf files. In many cases, you can do this by adding the user to the operating system user group mssql.

On Windows, do one of the following:

• Run the High-Volume Agent Listener service as the same Windows user that runs the source SQL Server service.
• Run the High-Volume Agent Listener service as another Windows user that has enabled the Debug programs (SeDebugPrivilege) policy. See Microsoft's documentation for more information about the Debug programs security policy.

Cause

This issue may occur if a user has not correctly followed our High-Volume Agent SQL Server installation prerequisites.