Qlik Replicate: [SQL Server]Login failed after an upgrade to Qlik Replicate 2022.11 or later

Steve_Nguyen — Mon, 27 Mar 2023 07:32:15 GMT

Qlik Replicate tasks with an SQL endpoint fail with:

[SQL Server]Login failed

The behavior began after an upgrade to Qlik Replicate version 2022.11 or later.

Resolution

In the Qlik Replicate UI:

Open the SQL endpoint and test the connection
If the test fails, verify if the credentials are using Windows authentication
With an upgrade to Qlik Replicate 2022.11 (and later), the Qlik Replicate service name was change from Attunity Replicate server to Qlik Replicate Server. See Service name change from Attunity Replicate Server to Qlik Replicate Server

The default service is run as local system account, which will not have access to your SQL endpoint.

Change the service back to run with the account that is able to login to the SQL server.
Test the connection/run the task.

See Working with Windows authentication | Qlik Replicate Help for details.

Cause

With an upgrade to Qlik Replicate 2022.11 (and later), the Qlik Replicate service name was change from Attunity Replicate server to Qlik Replicate Server. See Service name change from Attunity Replicate Server to Qlik Replicate Server

The default service is run as local system account, which will not have access to your SQL endpoint.

Environment

Qlik Replicate 2022.11 and later (upgrade)

article Qlik Replicate: [SQL Server]Login failed after an upgrade to Qlik Replicate 2022.11 or later in Official Support Articles

Qlik Replicate: [SQL Server]Login failed after an upgrade to Qlik Replicate 2022.11 or later

Resolution

Cause

Environment