SAP Knowledge Base Article - Public

2738479 - Why SDI MSSQLLogReader Adapter User access requires sysadmin privilleges, SDI

Symptom

Smart Data INtegration requires that MSSQLLogReader Adapter User be assigned sysadmin privilleges.

Environment

  • SDI 1.x/2.x
  • All Supported Platforms

Reproducing the Issue

NA

Cause

  • The Role ‘sysadmin’ is always checked during LogReader initialization, without it, QUEUE will fail.
  • Even with “Database Data Capture Mode” set to “MSCDC”, Role Sysadmin must be granted because LogReader call MSSQL system procedure sys.sp_cdc_enable_db
  • to enable data capture. Without sysadm we will hit error related to authorization.

Resolution

This is by design

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

Product

SAP SuccessFactors HCM Core 1811