Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
artempotsuray
Contributor III
Contributor III

SQL Server Connection Error

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

Labels (1)
7 Replies
Nicole-Smith

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.

artempotsuray
Contributor III
Contributor III
Author

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. 

Nicole-Smith

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.

artempotsuray
Contributor III
Contributor III
Author

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?

Nicole-Smith

The connection needs to be set up here on the server:
ODBC Admin.png

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.

artempotsuray
Contributor III
Contributor III
Author

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

Nicole-Smith

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.