topic Re: Unable to connect to Microsoft SQL Server in Connectivity & Data Prep

Unable to connect to Microsoft SQL Server

Anonymous — Mon, 30 Jan 2017 17:03:19 GMT

Hi,

My team is looking at using Qlik for slicing and dicing some data, so I downloaded the Qlik Sense Desktop software to try it out. But I have been unable to connect to our Microsoft SQL Server where the data resides.

There is no error code -- what's baffling is that I can't even get the software to try to connect. I opened up the "Create a connection - Microsoft SQL Server" dialogue, enter the DB information, and then...nothing happens. From the tutorial I know that I should click the little right arrow at the bottom of the page to initiate the connection, but that arrow is grayed out and clicking it does nothing. I've attached a screenshot so you can see what I mean:

(obviously I changed the actual host name, but it doesn't change the nature of the problem)

I talked to a sales associate who was very nice but couldn't help -- s/he said I should tag Mike Tarallo on this issue...

Any ideas?

Thanks,

Re: Unable to connect to Microsoft SQL Server

rittermd — Mon, 30 Jan 2017 17:46:06 GMT

It doesn't look like it is working correctly. Looks like it is waiting for something else to be entered even after you enter everything.

Instead of choosing Add Data click on Data Load Editor. Then click on Add Connection and choose OLE DB and fill in the information.

See if that works.

Re: Unable to connect to Microsoft SQL Server

Gysbert_Wassenaar — Mon, 30 Jan 2017 17:50:47 GMT

Try switching to the Date Load Editor and try to define a connection to your SQL database there. At least there you'll get a dialog window where you can test the connection.

Re: Unable to connect to Microsoft SQL Server

rittermd — Mon, 30 Jan 2017 17:50:55 GMT

As soon as you add the \ to type in the instance name you can't go any further. If you don't enter it then it will not connect.

192.168.30.201\ - this greys out the next arrow

Looks like a bug to me.

Re: Unable to connect to Microsoft SQL Server

Anonymous — Mon, 30 Jan 2017 18:49:22 GMT

You're right -- it does seem to the the backslash that's causing the problem. Not sure how I can connect to the server without it, though.

I tried going through the Data Load Editor. It seems to have 2 ways to connect:

1. Top left menu -> "Add data"

This brings up the same dialogue, with the same problem

2. Under "Data connections" on the right -> "Create new connection"

Makes a valid connection! Not fully confirmed yet because while it connects to the server okay, the specific database I'm looking for is missing so I can't load the actual data. This sounds like more of an internal problem, though, so I'll work through it with our IT.

In the meantime I'll call this a valid workaround. Thanks for the quick response!

Re: Unable to connect to Microsoft SQL Server

Anonymous — Thu, 02 Feb 2017 19:58:24 GMT

Update -- got our internal IT issues worked out and the connection works now. Thanks for the help!

Re: Unable to connect to Microsoft SQL Server

pumpkin_power — Wed, 24 May 2017 13:11:10 GMT

I have the same problem, my new SQL-Server has a \ in the Name and with it I cant connect anymore. As soon as I type the \ the arrow gets Grey.