eeyo
asked on
Is it possible to connect to SQL Server through 1)TeamViewer VPN or through 2) RDP, both indirectly
I frequently need to use SQL Server Management Studio to remotely connect to SQL Server Database on 10.x.x.1. I can connect to the network via either
With RDP, I try to ping 10.x.x.1 (but it returns the same random 72.x.x.x expired in transit).
Does anyone know how I can connect to the Database located on 10.x.x.1 with SQL Server Management Studio via either of my connections (or both if possible)? I have not tried to bridge the connections, partly because I am not sure of the repercussions.
1) Teamviewer (with it's built-in VPN) to another workstation on the domain 10.x.x.2, or
2) RDP (via SBS 2011 Essentials) directly to the database server on 10.x.x.1
With Teamviewer, I can ping the non-server workstation via the ad-hoc network at 7.x.x.1, but I try to ping 10.x.x.1 (but it returns a random 72.x.x.x expired in transit).2) RDP (via SBS 2011 Essentials) directly to the database server on 10.x.x.1
With RDP, I try to ping 10.x.x.1 (but it returns the same random 72.x.x.x expired in transit).
Does anyone know how I can connect to the Database located on 10.x.x.1 with SQL Server Management Studio via either of my connections (or both if possible)? I have not tried to bridge the connections, partly because I am not sure of the repercussions.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was hoping to do this without a 3rd party VPN. PPTP may be less secure. OpenVPN is a little tricky, and isn't easily done by novice in 5 minutes.
PPTP is safe enough if you are not connected all the time, and choose a complex password (this is used for encryption and keying).
More secure = more complex.
OpenVPN is as safe as you choose the parameters, like any other VPN.
More secure = more complex.
OpenVPN is as safe as you choose the parameters, like any other VPN.
ASKER
Management Studio is already installed, but I need to connect remotely because I also need to run other database applications that I can't directly install on the server.
Can you point this newbie in the right direction? Is this possible with Teamviewer VPN? Is there something I can set up with the SBS 2011 Essentials OS server (where SQL Server is installed) without having to install third party software?