topic Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud in Data Movement & Streaming

Not Able to Connect Local SQL Server from Qlik Sense Cloud

AkshayDabhi — Wed, 19 Mar 2025 23:04:08 GMT

When i have try to connect Local SQL Server from qlik sense it gives me follwing error:

ERROR [08001] [Qlik][SqlServer] Failed to locate Server/Instance Specified

I have performed following steps to connect Local SQL Server:
- select Microsoft SQL Server from data source and fill the required information's like : Server Name , Database name and then provide credentials to connect local server then it will gives error. I have also check prerequisite like check port number 1433 is run mode or not and all the service of SQL server is running or not , all the required service is in running mode yet its gives me error.

so can anybody suggest me what to do in this scenario or can give any extra step to follow which i have supposed to do in this process.

Thanks in Advance

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

fmarvnnt — Tue, 04 Apr 2023 10:22:39 GMT

It is because you are accessing a server not exposed to internet. Two solutions: espose the server to internet ; use Qlik Data Gateway - Direct Access installed on a local server that permitt to access the local server. More on https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway.htm .

FMa

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

AkshayDabhi — Tue, 04 Apr 2023 12:48:28 GMT

As per step I have created a gateway but when try to connect MS SQL through direct access gateway connector it is giving below error

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

fmarvnnt — Tue, 04 Apr 2023 13:36:07 GMT

Try to create an ODBC connection from the Qlik data Gateway Windows server to the SQL Server using the internal IP anche check the result; if it works, use the IP in the Direct Access...

FMa

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

Frank_S — Tue, 04 Apr 2023 21:46:55 GMT

@AkshayDabhi

Which DADG connector are you using?

Use the one designed for use with Direct Access Data Gateway as shown below.

Make sure you

use the correct SQL user ID and password (if SQL authentication is enabled)
and ensure the connection settings are accurate. (see https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/SQLServer/Create-SQL-Server-connection.htm)

Kind regards...

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

AkshayDabhi — Wed, 05 Apr 2023 06:20:24 GMT

Thank you @fmarvnnt for your suggestion.
before the TCP/IP port is disabled on my system now it is running and able to connect local sql server from qlik sense by using your provided link

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway.htm?_ga=2.6562866.1489561875.1680497933-1687970093.1659954647&_gac=1.91957864.1680502267.CjwKCAjw_MqgBhAGEiwAnYOAekGdQ1jL6NGddqQVDPH7fTIkV5iSjabZAG1CPMMvz_ETg5QYK7BoWRoC34UQAvD_BwE

Thank you for your support.

Re: Not Able to Connect Local SQL Server from Qlik Sense Cloud

AkshayDabhi — Wed, 05 Apr 2023 06:21:43 GMT

thank you @Frank_S for your support!!