topic Re: qliksense hub oledb provider for sql server not connecting in Connectivity & Data Prep

qliksense hub oledb provider for sql server not connecting

Wed, 25 May 2016 13:04:31 GMT

I am trying to connect to an sql server that is on a separate machine. I am getting a ping reply from that machine but when I try to create a new connection on qliksense hub, it fails

I am assuming that it is because the hub is using a different port than what we opened for our database server

Is there any way to tell the hub to use some specific ports for connecting to the sql server?

Which ports is it using by default by the way?

Arif

Re: qliksense hub oledb provider for sql server not connecting

Wed, 25 May 2016 13:25:39 GMT

Hi,

Each and every settings of all ports and proxies are available in proxy services section of QMC. So you can check or change the settings from there only.

Regards,

Brijesh.

Re: qliksense hub oledb provider for sql server not connecting

Gysbert_Wassenaar — Wed, 25 May 2016 14:59:14 GMT

Normally you need only access to ports 1433 and 1434. It's possible to specify the port in the connection string. "Provider=SQLOLEDB;Data Source=oursqlserver.ourdomain,1433; Initial Catalog=ABC"

Perhaps this article helps: SQL Server TCP and UDP Ports | SQL Server content from SQL Server Pro

Re: qliksense hub oledb provider for sql server not connecting

Thu, 26 May 2016 08:31:08 GMT

Ok I am still having problem. So I have two machines on the same network. One machine has sql server installed and the other one has the qliksense hub. I have full access to the sql server and its databases. Also, when I try to ping the sql server machine from qliksense hub machine, I also get a ping reply

However, when I try to create an oledb provider for sql server connection and use windows integrated security, it does not work. When I try to click on create connection, I get an error that you do not have access to this datasource

Can you please help me fix this.

Regards

Syed

Re: qliksense hub oledb provider for sql server not connecting

Gysbert_Wassenaar — Thu, 26 May 2016 16:20:05 GMT

Does the service account that you use for Qlik Sense also have access to the database? Perhaps you should ask your local friendly database administrator for help troubleshooting this.

Re: qliksense hub oledb provider for sql server not connecting

Fri, 27 May 2016 06:22:15 GMT

Yes, I have full access to the database. When I use sql server management studio, I can do all the queries on the database. According to the db guy, 59061,59104,53374 are the ports open/used by the database. I tried these ports in the connection string but could not get them working

Re: qliksense hub oledb provider for sql server not connecting

Anonymous — Wed, 08 Jun 2016 19:05:03 GMT

Hi,

we have the same issue.

we are able to connect to SQL Server vía ODBC but we are not able to create the connection from qliksense hub

do you have any advice for this issue?

thanks in advance

Re: qliksense hub oledb provider for sql server not connecting

Anonymous — Mon, 19 Jun 2017 01:11:55 GMT

It could be you dont have permission on your apps. give additional access in qlik sense qmc app section so that you can create connection. if you have steam, give stream additional access.

If thats all good, then please ping your db server first. if thats correct, check user security in database server.

You are using windows integrated security, you both Qlik server and database server must be on same domain or trusted domain.

Thanks

Qaiser

Re: qliksense hub oledb provider for sql server not connecting

ma258827 — Thu, 07 Sep 2017 15:20:37 GMT

Hi Gysbert,

I have to setup MS OLE DB provider for Analysis Services 11.0, but i don't see it on my OLE DB list of connectors.

do i need to install it explicitly.

if yes, could you please share the links and related docs..

Thanks, Manish

Re: qliksense hub oledb provider for sql server not connecting

jerrysvensson — Fri, 08 Jun 2018 12:02:23 GMT

I have the same problem. Although test connection says OK, which I found out doesn't mean a thing.

When I press Load and then try to Select database, the list is empty. Very strange.

The service account does not have access to the database. But my account has.

OLE DB Problem, no database in Select database...

Re: qliksense hub oledb provider for sql server not connecting

thomas_evans — Sun, 01 Jul 2018 21:18:51 GMT

Same issue here, did you find a fix for this?

Seems odd, I found I can put any old password / username (even if it doesn't exist) in there and it validates as OK.

Can ping the SQL server fine.

Correct user and password combination, still cannot select database.

Error returned is "Connector Connect Error {0}"

ODBC works fine.

Re: qliksense hub oledb provider for sql server not connecting

Anonymous — Wed, 04 Jul 2018 12:04:26 GMT

Hi,

Also facing the same problem and also using ODBC.

Any of you figured out the problem?

Re: qliksense hub oledb provider for sql server not connecting

jerrysvensson — Thu, 05 Jul 2018 05:37:04 GMT

Which version of Sense are you running?

Re: qliksense hub oledb provider for sql server not connecting

Anonymous — Thu, 05 Jul 2018 07:50:20 GMT

Hi,

February 2018 release.

It stopped working (we think) after changing the Service Account password and is only happening with Hana connections. I can't create a new ODBC connection in Sense and I get the same error "You do not have access to the data source".

Creating and testing a Data source in ODBC administrator works just fine and creating ODBC connections in Sense to Oracle, for example, also works fine.

We already reinstalled the hdbodbc drivers, added the new SA password to all Qlik services (except database) again and restarted them in the correct order. But nothing worked so far.

Re: qliksense hub oledb provider for sql server not connecting

jerrysvensson — Thu, 05 Jul 2018 12:15:47 GMT

Strange.

We are running april release.