Error when replicating tables from MS SQL Server DB using Qlik Replicate

[Alihoussene]

Hi,

I tried to replicate some tables from MS SQL Server DB as Source to Snowflake as target using Qlik replicate and Both connections are well established and work well. But when I runed the task, I encountered the error below: 

Date and Time Level Message
10/10/2022 3:37:17 PM WARNING_GENERAL Task 'replication' encountered a fatal error
10/10/2022 3:37:17 PM ERROR_GENERAL "Stream component 'st_0_source' terminated
Stream component failed at subtask 0, component st_0_source
Error executing command
Failure upon initial CAPTURE fitness checking
Unable to verify existence of artifact required for DBOWNER permission
mssql_perm_approve_object_existence(...) ended with CREATE() error:
select 1
from master.sys.objects o
inner join master.sys.schemas s on o.schema_id = s.schema_id
where o.name = 'rtm_dump_dblog'
and o.type = 'P'
and s.name = 'attrep'

RetCode: SQL_ERROR SqlState: 42000 NativeError: 40515 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Reference to database and/or server name in 'master.sys.objects' is not supported in this version of SQL Server. Line: 1 Column: -1
mssql_perm_approve_object_existence(...) ended with CREATE() error:
select 1
from master.sys.objects o
inner join master.sys.schemas s on o.schema_id = s.schema_id
where o.name = 'split_partition_list'
and o.type = 'TF'
and s.name = 'attrep'

RetCode: SQL_ERROR SqlState: 42000 NativeError: 40515 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Reference to database and/or server name in 'master.sys.objects' is not supported in this version of SQL Server. Line: 1 Column: -1"

I hope someone could help me fix it. 

[Dana_Baldwin]

Hi @Alihoussene 

I assume this is a new task, correct?

Do you have other tasks successfully using this same source endpoint? Not just the same database, but using the same source endpoint as defined?

Thanks,

Dana

[Alihoussene]

Hi @Dana_Baldwin ,
This is the first task I've configured with this source endpoint  and it's the only task I have.
Thanks

[Heinvandenheuvel]

The error message from SQLserver is very explicit : "Reference to database and/or server name in 'master.sys.objects' is not supported in this version of SQL Server."

What version SQLserver version is being used? Which Replicate version (top right GUI, and first line in log).

Is that SQLserver version supported as source?

https://help.qlik.com/en-US/replicate/May2022/pdf/Replicate-Support-Matrix.pdf

While the error message is explicit and needs to be checked from that angle, sometimes issues like this a security related. Make sure the username used has 'max' privs, at the very least during a retry maybe forever, and try the query in SMSS using the same username vs using dbadmin.

Hein.

[Alihoussene · Accepted solution]

Thanks for the responses, I've followed the Qlik replicate user guide for MS SQL Server endpoint 
I should make some configs before using the server for replication. I've followed the guide as describe in the section    Microsoft Azure SQL Managed Instance as a source . I didn't configure the required permissions.

Thanks