Have setup and activated the Qlik Data Gateway - Direct Access on an On-Prem server.
Data Gateway is showing as connected via the QMC
I've tried to setup a Microsoft SQL Server (via Access Data Gateway) to connect to an ODBC connection but i'm unsure as to the settings, can some explain the process or answer the below:
What driver should the ODBC connection be setup using, i've setup two using:
- Qlik-mssql - (named Source1)
- SQL Server - (named Source2)
Both Test Connections = Success.
On Qlik Saas - using the the "Microsoft SQL Server (via Direct Access gateway)" connector what parameters should be entered?
For server i've tried the following combinations without success
Every time i receive this error:
Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection - ERROR  [Qlik][SqlServer] Failed to locate Server/Instance Specified.")
I can find no documentation as to how this should be setup.
Would appreciate anyone's help.