Qlik Community

Qlik Sense Data Connectivity

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

moslem_teymoori
Contributor

Remote connection failure

I am trying to connect to a remote data base through a VPN, the local cnnection works and i can ping the host through the vpn, but i can not get access to the SQL server data base running on the host's pc.

i get the following error message while trying to connect

Capture.JPG

3 Replies
felipedl
Valued Contributor III

Re: Remote connection failure

Hi Moslem,

Your print shows you have Windows Authentication on, so the connection to the DB will be made on your currently logged user on your machine (i'm assuming your user does not have access to the DB by the way).

Does the other option work for you when you state the specific user?

You would need to use the database user to log.

Since you can access the VPN's machine, it would be as any other network connection as I see it.

See this post for some information:

Using a Windows Service Account in a DB Connection

moslem_teymoori
Contributor

Re: Remote connection failure

True , it needed user and pass for the authentication , i solved the connection , Thanks

felipedl
Valued Contributor III

Re: Remote connection failure

No problem, can you mark the anwser as correct if it helped you please?

Community Browser