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

[Steve_Nguyen]

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:

1. Open the SQL endpoint and test the connection
2. If the test fails, verify if the credentials are using Windows authentication
3. 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.
   
4. 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)