Qlik Sense SQL ODBC 17 error

[jrathgebercs]

Hi All,

I am trying to connect Qlik Sense SQL ODBC data source using system DNS. I have added the required details in system DNS ODBC. When i am trying to connect the source getting this error in connection. Adding screenshots below.

Qlik Hub error:

ODBC Driver Error During test:

Thank you.!!

[mpc]

Hi, 

Please check your firewall, on both Qlik Sense and SQL Server. You can try to Telent the SQL Server from the Qlik Sense one. 

Then, check the name of your server. Also are you using Kerberos auth ? 

Best

[jrathgebercs]

Hi @mpc ,

Thank you for your response.

We are not using Kerberos Authentication.

Configuration details.

Test Data source Error: Getting this error now.

Thank you.

[jrathgebercs]

Also what we need to check on Qlik Sense and SQL firewall. I mean what we need to enable Or should i reach out to network team for this?

[mpc]

By using the telnet command from the Qlik Sense server and trying to reach the MSSQL server, you'll see if any problem occurs on the proxy. 

If the telnet is OK, then the problem is not the firewall; If not, it can be this, and you will need to open the correct port inbound on the MSSQL server(default is TCP 1433). 

Best

[jrathgebercs]

Hi @mpc ,

I have checked the telnet command with server name and port from Qlik Sense server. Its reaching out to sql server.

[mpc]

So port is open. 

Did you try to connect with your user directly on the MSSQL server ? 

[marksouzacosta]

Hi @jrathgebercs ,

Make sure the user you are using have all necessary privileges to access the Database.
One way I like to use is to install the SQL Server Management Studio on the machine where I'm trying to access the Database from and establish the connection. In my opinion, the connection errors on Management Studio are clearer to ready than ODBC Drivers.

That way, you can make sure you are using the correct parameters and have all the privileges that you need to access the Database.

Regards,

Mark Costa