Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gregdebbe1
New Contributor

Qlik Sense Desktop Microsoft SQL Server Connection Failure

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.

Qlik Setup1.PNG

Qlik Setup2.PNG

Qlik Error.PNG

9 Replies
satishkurra
Valued Contributor II

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

I tried at my end and do not see any problem.

We can use both ODBC and OLE. Attached screenshot i used OLE

ogster1974
Honored Contributor II

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

Try creating the same sql connection in excel to confirm your details you are using are correct.  

I always use the server IP address in my credentials.

gregdebbe1
New Contributor

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

This response is not related to the type of connection I am trying to make but I have tried an OLE DB connection and that is not successful either.

gregdebbe1
New Contributor

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

I found the issue but I don' have a solution for it.   In order to connect to the server, I need use a "\" in the server property field.  servername\sqlservername or ipaddress\sqlservername

I tested both scenarios with the server name and the ip address of the server in excel as suggested by Andy Weir and they connect.

When I put the "\" in the server property of the Microsoft SQL Server connection, I lose the ability to even click the "Create" button on the connection.

See below. In the first screen print, the "Create" button is grayed out.  In the second screen print, the "Create" button is not grayed out but that type of value is not going to get me connected.

Qlik Setup3.PNG

Qlik Setup4.PNG

kenphamvn
Contributor III

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

Hi

Some characters are not allowed in connection name, please remove '\' in name of connection,

Regards

An Pham

1-18-2018 9-07-12 AM.png

gregdebbe1
New Contributor

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

I changed the connection name as recommended and I am able to click on the Create button now but I still receive the same error message.  I was able to get an OLE DB connection connected but the Microsoft SQL Server connection still does not connect using the same credentials as the OLE DB connection.

Employee
Employee

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

Dear Greg,

Had you tried to pass the credentials with the domain attribute?

Did you test a "telnet" command through TCP port 1433?

The easy way to create a new data connection is testing from the SQL Local server then copying the configurations to another computer.

verocarrera
New Contributor

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

I have the same exact issue. I was able to get the OLE DB connection with same credential the MS SQL Server connection is rejecting.

rperezlaso
New Contributor III

Re: Qlik Sense Desktop Microsoft SQL Server Connection Failure

try to check

  • Sql server – SQL SERVER NETWORK CONFIGURATION -> PROTOCOLS FOR SQLEXPRESS -> TCP/IP DISABLED

if its disabled you cant connect it .

Community Browser