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
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
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)
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 .
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 ?