https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127719#M7684 <P>The error message is incorrect it should read:&nbsp;</P> <UL> <LI>A member of both the<SPAN>&nbsp;</SPAN><CODE>db_owner</CODE><SPAN>&nbsp;</SPAN>database role <STRONG>and</STRONG> the<SPAN>&nbsp;</SPAN><CODE>sysAdmin</CODE><SPAN>&nbsp;</SPAN>fixed server role.</LI> </UL> <P>AND, not OR</P> <P>Hein.</P> Wed, 11 Oct 2023 22:19:08 GMT Heinvandenheuvel 2023-10-11T22:19:08Z https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127369#M7667 <P>I got this error when running replicate from SQL Server Source to ODBC (IBM DB2 for iSeries) Target</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_0-1697012246158.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118025i8E17AD5F0A3ABB7B/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_0-1697012246158.png" alt="DuongNguyen_0-1697012246158.png" /></span></P> <P>the account I have set db_owner permissions!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_0-1697012734197.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118026iC99E49852BCDD541/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_0-1697012734197.png" alt="DuongNguyen_0-1697012734197.png" /></span></P> <P>how to fix it?</P> Wed, 11 Oct 2023 08:25:46 GMT https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127369#M7667 DuongNguyen 2023-10-11T08:25:46Z https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127375#M7668 <P>Hello Team,</P> <P>Request you to follow the instruction mentioned in the help Document when you are using&nbsp;<SPAN>SQL Server as a Source endpoint.</SPAN></P> <P><A href="https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/SQL%20Server/SQLServer_DB_source.htm" target="_blank">https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/SQL%20Server/SQLServer_DB_source.htm</A></P> <P>As its have Some pre-requisite in term of</P> <P>Prerequisites<BR />Required permissions<BR />Setting up Microsoft SQL Server for replication</P> <P>Regards,</P> <P>Sushil Kumar</P> <H1>&nbsp;</H1> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 11 Oct 2023 08:33:02 GMT https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127375#M7668 SushilKumar 2023-10-11T08:33:02Z https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127719#M7684 <P>The error message is incorrect it should read:&nbsp;</P> <UL> <LI>A member of both the<SPAN>&nbsp;</SPAN><CODE>db_owner</CODE><SPAN>&nbsp;</SPAN>database role <STRONG>and</STRONG> the<SPAN>&nbsp;</SPAN><CODE>sysAdmin</CODE><SPAN>&nbsp;</SPAN>fixed server role.</LI> </UL> <P>AND, not OR</P> <P>Hein.</P> Wed, 11 Oct 2023 22:19:08 GMT https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127719#M7684 Heinvandenheuvel 2023-10-11T22:19:08Z https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127912#M7697 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_0-1697103372318.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118116i417C1AFAC23EC400/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_0-1697103372318.png" alt="DuongNguyen_0-1697103372318.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DuongNguyen_1-1697103383505.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/118117iC4EE7C4BC1E68D69/image-size/medium?v=v2&amp;px=400" role="button" title="DuongNguyen_1-1697103383505.png" alt="DuongNguyen_1-1697103383505.png" /></span></P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/110970">@Heinvandenheuvel</a>&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149217">@SushilKumar</a>&nbsp;I set user has permission sysadmin and db_owner but it still has the same problem as above</P> Thu, 12 Oct 2023 09:39:40 GMT https://community.qlik.com/t5/Qlik-Replicate/Failure-upon-initial-CAPTURE-fitness-checking/m-p/2127912#M7697 DuongNguyen 2023-10-12T09:39:40Z