i am currently using Qlik Sense 2017 edition and while i am trying to connect to a database it showing the below error..
can any one let me know the way to resolve it.....
which database you want to connect?
please ensure the port connect to database is open (ex default port: 1521 for Oracle, 1433 for sqlserver) and qlik server allowed connect to Database server
and username/password is correct?
Thanks for the reply Pham
i want to connect to microsoft SQL
and credentials and port number are correct itself.
Qlik support connect to SQL via (ODBC, OLE DB...), you do not need install additional connector
Here my example connect to SQL server using OLE DB
Thanks a lot Pham.
If you use qlik sense desktop you must first create an odbc connection. Either user or system dns.If you use qlik cloud you must have a static ip and open the port of router 1433 and direct it to the computer that has the SQL.
Thanks for the useful info Castellano.
Retrieving data ...