Qlik Sense Desktop Microsoft SQL Server Connection Failure

[Anonymous]

I am new to Qlik and only have the free version.  Support will not help me at all and has directed me to the community.  As a potential buyer of this software I am initially finding this to be a red flag for making a purchase.

I am trying to connect to a SQL server with the Microsoft SQL Server connection.  Below are screen shots of the setup filled in with generic property values along with a meaningless error message. I have tried pretty much every possible combination of server credentials I know.  I have used server name, ip addresses, local sql user credentials, windows user credentials, etc...  I know the credentials are valid but no matter what I try entering, the same exact error message is the result. 

Clicking on the question mark in the upper right hand corner takes you to the link directly below which really offers no help whatsoever.  I doesn't even follow along with the actual wording as the connection setup.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/3.0/SQLServer/Create-M...

I have searched the community and found a few discussions that are similar in nature but none have been helpful to get to a solution.  Can anyone offer some advice on getting the SQL server connection working.

[cbrammer1219]

I see this is an old post and hopefully someone will respond, I was able to make a connection to excel, but can not get the Microsoft SQL Server datasource configured...any ideas?

[siewwei]

My excel can connect, but not the QlikCloud, please assists.