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)
