Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
Which DADG connector are you using?
Make sure you
Kind regards...
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
Thank you for your support.
thank you @Frank_S for your support!!