Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
moslem_teymoori
Creator
Creator

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
Partner
Partner

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
Creator
Creator
Author

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

felipedl
Partner
Partner

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