topic SQL Connection Issues in QlikView

SQL Connection Issues

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to connect to a remote Computer and access the SQL Server database through a VPN,
when i ping the host the connection is fine and works properly.
but when i try to connect to the sql running in the host"s pc i get connection error

Re: SQL Connection Issues

hallquist_nate — Tue, 19 Dec 2017 19:58:57 GMT

Are you getting an "Access Denied" message, or are you getting a message stating that "...can't find Server/Database?"

Nate

Re: SQL Connection Issues

ravikumar_iyana — Wed, 20 Dec 2017 02:56:55 GMT

Hi Moslem,

That is belongs to Authentication Issue only , Ones do cross check with your Manager .

They will rise the access for u

Thanks,

Ravi

Re: SQL Connection Issues

devarasu07 — Wed, 20 Dec 2017 03:25:03 GMT

Hi,

Try to make sure your SQL server IP/host name and db login credentials working.

also do simple telnet ping from your end

C:\>telnet sqlserver_ip_address 1433

just change the Authentication type from SQL Server authentication instead of Windows

Re: SQL Connection Issues

SunilChauhan — Wed, 20 Dec 2017 05:50:10 GMT

i believe need to select second option

"specific username and password"

Re: SQL Connection Issues

Anil_Babu_Samineni — Wed, 20 Dec 2017 06:16:54 GMT

When you say you are using VPN i believe you need to connect VPN and The remote is an another cluster with different nodes. So, I would ask you to test by yourself using that connection whether you can access DB or not (I meant to say privileges of account RDC)

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 08:31:06 GMT

Thank you for your replym, this is the error(SQL SERVER does not exist or Access Denied ) . i try to ping the host using a simple ping command in command prompt of windows and the VPN connection is fine , i also tried the ip address before the server name(192.168.11.1\ server name and instance name ) but no luck .

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 08:33:35 GMT

Hey kumar, i have the access and Authentication, and the SQL in the host does not need any username and password , they use windows authentication only

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 08:39:37 GMT

Thank you for your reply
i am using the Windows 10, i can not use the command Telnet , i just tried a simple ping from the command line and i got the response ,
the host also uses windows Authentication there is no username and password, or maybe i shoud give my own username and pass, don't i ?

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 08:40:57 GMT

the host uses Windows Autentication , do i have to have username and password ?

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 08:43:39 GMT

thank you dude,
what is RDC ? would you explain more in detail ? the host is using windows server but the firewall is off .

Re: SQL Connection Issues

SunilChauhan — Wed, 20 Dec 2017 08:44:19 GMT

i believe windows integrated security option does not require username and password

Re: SQL Connection Issues

devarasu07 — Wed, 20 Dec 2017 08:49:56 GMT

Hi,

If your trying with your own SQL database installed machine then u can use both Windows /SQL authentication type and it should work and you can able connect via qliksense. suppose if your trying to connect with your office SQL server you need check the your manager/database team for the SQL authentication type , user credential (because windows authentication mode work won't work).

p.s: windows authentication type will work only where u have installed SQL instance.

hope this helps to you

Regards,Deva

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 17:00:31 GMT

it needed the user and pass even if on the host pc it was windows authentication ,

Thank you so much

Re: SQL Connection Issues

Anonymous — Wed, 20 Dec 2017 17:01:22 GMT

it needed the user and pass even if on the host pc it was windows authentication ,

Thank you so much

Re: SQL Connection Issues

devarasu07 — Wed, 20 Dec 2017 17:20:09 GMT

Hi,

User Name & Password is Not required if your using local machine (make sure u r machine a/c already added in sql instance during the installtion)

refer the sample o/p using windows authentication without logic credentials.

Re: SQL Connection Issues

devarasu07 — Wed, 20 Dec 2017 17:21:39 GMT

Hi,

Hope it's clear now, help to close this thread by marking helpful and correct. Thanks Deva

Re: SQL Connection Issues

Anonymous — Thu, 21 Dec 2017 08:09:14 GMT

thanks buddy