Remote connection failure

[Anonymous]

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

[felipedl]

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

[Anonymous]

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

[felipedl]

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