Edit on GitHub
Error: F_JD0A57 Failed To Retrieve Database Server Process Handlelink
Issuelink
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.
Environmentlink
Connector: HVA SQL Server
Resolutionlink
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, such as Local Data Processing database user, that has enabled the
Debug programs
(SeDebugPrivilege
) policy. See Microsoft's documentation for more information about theDebug programs
security policy.
Causelink
This issue may occur if a user has not correctly followed our High-Volume Agent SQL Server installation prerequisites.