topic Re: SQL Server Connection Error in Connectivity & Data Prep

SQL Server Connection Error

artempotsuray — Wed, 15 Dec 2021 17:35:13 GMT

Hello Everyone,

I'm having an issue connecting to a server on Qlik Sense Enterprise. I am able to make the connection to the server using my computer (via ODBC) and even able to pull data from that server using Qlik Sense Desktop. I have tried using both Microsoft SQL Server and OLE DB and both fail.

I get the following error:

Please check the values for Username, Password, Host and other properties.

Details:

ERROR [08001][Qlik][SqlServer] Failed to locate Server/Instance Specified

I don't know why I'm able to connect to the server and use it on the desktop version but not on Qlik Sense Enterprise. Any help or insight on why this could be happening is appreciated.

Thanks in Advance

Re: SQL Server Connection Error

Nicole-Smith — Thu, 17 Jan 2019 19:55:22 GMT

Is the ODBC connection set up on the Enterprise Server under the Windows settings (ODBC Administrator)? Maybe the ODBC data source has only been set up on your computer (why you can run it on there) but not on the server.

Re: SQL Server Connection Error

artempotsuray — Tue, 29 Jan 2019 16:56:51 GMT

Sorry for the late reply,

No, I am only using a ODBC connection on my desktop version. On the server version I am trying to make the connection using Microsoft SQL Server or OLE DB. I mention ODBC to show that I am able to make the connection. In other words, the server is accessible just not from the server version of QLIK.

Re: SQL Server Connection Error

Nicole-Smith — Tue, 29 Jan 2019 17:46:48 GMT

If you're using ODBC in developer, you can use the same on the server. You will need to set up that ODBC connection in ODBC Administrator on the windows server.

The only other issue would be if the user that the Qlik server is using to run everything doesn't have access to the SQL server. That user would need to be given permissions in order to access it.

Re: SQL Server Connection Error

artempotsuray — Tue, 29 Jan 2019 18:46:15 GMT

Unfortunately I don't have permission to setup the ODBC in the developer. As for access to the server, the owner of the developer has told me he is able to ping the server and find it. Does he need to do something within the developer to allow me to make that connection?

Re: SQL Server Connection Error

Nicole-Smith — Tue, 29 Jan 2019 19:16:56 GMT

The connection needs to be set up here on the server:

It's a Windows setting (has nothing to do with Qlik settings). The ODBC connection needs to be set up there though in order to use it on the Qlik server.

Re: SQL Server Connection Error

artempotsuray — Tue, 29 Jan 2019 19:53:19 GMT

I do have the connection setup. I am able to connect to the server successfully when I test the connection.

Re: SQL Server Connection Error

Nicole-Smith — Wed, 30 Jan 2019 17:07:24 GMT

Are you sure that the user the Qlik server is using to hit the connection has access to the SQL server? The user it's using could be different than your user.