topic Re: Connection String Failure for SQL DB in QlikView

Connection String Failure for SQL DB

Fri, 17 Jan 2014 10:02:09 GMT

Hi Folks,

I am facing problem while pulling data from SQL DB.

It is showing me test connection successful but throws an error after clicking on OK.

PFA for Error Massage.

Thanks.

- Yojas

Re: Connection String Failure for SQL DB

Peter_Cammaert — Fri, 17 Jan 2014 10:15:12 GMT

Test connection only checks whether the RDBMS can be reached.

You're trying to access a SQL Server instance with an account that belongs to a different domain than the one in which SQL server resides, and the two domains do NOT have a trust relationship (they don't trust each other at face value). You can have that when on the QVS-machine you try to login into SQL server from a local machine domain.

Use a different account, or talk to your Admin about trusted domains.

Peter

Re: Connection String Failure for SQL DB

maxgro — Fri, 17 Jan 2014 10:18:30 GMT

if you have a sql username and password change to sql authentication

Regards

Re: Connection String Failure for SQL DB

Fri, 17 Jan 2014 10:22:16 GMT

Hi Peter,

Can you please elaborate your point because I am in the LAN network and able to pull one DB from Sql and facing problem for the 2nd DB.

Thanks!!

Regards,

Yojas

Re: Connection String Failure for SQL DB

Fri, 17 Jan 2014 10:23:21 GMT

Hi Massimo,

Can yes currently I am using username & password for SQL Authentication.

Regards,

Yojas

Re: Connection String Failure for SQL DB

Peter_Cammaert — Fri, 17 Jan 2014 10:24:41 GMT

Does the 2nd DB reside in the same SQL Server environment, or in a different one?

Peter

Re: Connection String Failure for SQL DB

Fri, 17 Jan 2014 10:29:59 GMT

Hello,

Can you create ODBC connection for SQL Server. If you get successful, then try connecting in QV through ODBC.

Re: Connection String Failure for SQL DB

Peter_Cammaert — Fri, 17 Jan 2014 10:34:59 GMT

Probably not in the same SQL Server environment, because the second DB can only be entered with a valid Windows Account (Authentication mode=Windows Authentication), while below you say that you are trying to use a SQL Server Account name & password for authentication. DB2 only allows windows users to log in (via SSO) but your domains have to trust each other for this to work.

Talk to your Admin.

Peter

Re: Connection String Failure for SQL DB

Fri, 17 Jan 2014 10:56:19 GMT

Hi,

Can u check if ur QV-machine has SQL 11 client installed on it

and that client has authorization in your SQL Server??

-Shruti