Failure upon initial CAPTURE fitness checking

[DuongNguyen]

I got this error when running replicate from SQL Server Source to ODBC (IBM DB2 for iSeries) Target

the account I have set db_owner permissions!

how to fix it?

[SushilKumar · Accepted solution]

Hello Team,

Request you to follow the instruction mentioned in the help Document when you are using SQL Server as a Source endpoint.

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/SQL%20Server/SQLServer_DB_sourc...

As its have Some pre-requisite in term of

Prerequisites
Required permissions
Setting up Microsoft SQL Server for replication

Regards,

Sushil Kumar

 

[Heinvandenheuvel · Accepted solution]

The error message is incorrect it should read: 

• A member of both the db_owner database role and the sysAdmin fixed server role.

AND, not OR

Hein.

[DuongNguyen]

@Heinvandenheuvel @SushilKumar I set user has permission sysadmin and db_owner but it still has the same problem as above