Not Able to Connect Local SQL Server from Qlik Sense Cloud

[AkshayDabhi]

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

[fmarvnnt · Accepted solution]

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-g... .

FMa

[AkshayDabhi]

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

[fmarvnnt]

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

[Frank_S]

@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/SQ...

Kind regards...

[AkshayDabhi]

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-g...

Thank you for your support.

[AkshayDabhi]

thank you @Frank_S  for your support!!