Hello:
I have 3 servers running on my machine. 1) HPW7V64, 2) HPW7V64\SQLEXPRESS, 3) HPW7V64\IPSQLSERVER.
If I use the following lines I can connect to #1:
TestConnection.ConnectionString = @"Server=hpw7v64.ggamvpn.gbridge.net;Database=IPDev...
TestConnection.ConnectionString = @"Server=HPW7V64;Database=IPDev...
I would like to connect to #2 & #3 with the VPN. Anyone know how I can pass the correct string?
Loading
theLizardPosted Mar 5, 2010, 1:21 AM
If it is then this is how gbridge can work from anywhere in the world and this opens up your system to intrusion to be used for who knows what!
again this is my interpretation without doing a hell of a lot more research into gbridge but I know enough that gbridge is linked with a crowd in Germany with their servers hosted in the US but they could also be using a pass through.
Possibly why you cannot connect with the others is that they are virtual and gbridge would not have access to IP address that you may have setup or that wehere setup for you when you installed the virtual servers.
theLizardPosted Mar 5, 2010, 1:32 AM
GustavoPosted Mar 5, 2010, 1:26 AM
I know... The security is scary. GBridge does have some security, but they might be able to access it, its their program. I do have a firewall, but who knows if its good enough.
I would like ot close this issue and go to the next step.
GustavoPosted Mar 5, 2010, 1:11 AM
Yes... I am a bit worried about the security...LOL.
I have 1 machine with 3 virtual machines for testing. If I have only one server I can use the vpn and connect without any issues. Its the multiple servers that are an issue. If I cant get it to work, I will probably remote the other 2.
theLizardPosted Mar 5, 2010, 1:07 AM
It would probably be safe to say that you could not use their service for what you intend again this is my first impression.
I would look at your local machine IP address for the connection if you can.
Q. how many machines do you have physically located at where you are?
using System.Data.SqlClient; This is ok...
GustavoPosted Mar 5, 2010, 1:03 AM
Let me check out GBridge, but if the DB is on your machine you should be able to connect to it direct. Yes, I know I can, but I want to be able to connect to it remotely also.
What version of sql are we talking about? I am using MSSQL 2008 and the SQLEXPRESS 2008.
What provider are you using to connect? Not sure how to answer this one. I am using the statement: using System.Data.SqlClient;
My full connection string is:
TestConnection.ConnectionString = @"Server=hpw7v64.ggamvpn.gbridge.net\SQLEXPRESS;Database=IPDev;User ID=GGAMRemote;Password=***********;";
theLizardPosted Mar 5, 2010, 12:55 AM
What version of sql are we talking about?
What provider are you using to connect?
GustavoPosted Mar 5, 2010, 12:51 AM
GBridge.net is a free VPN that you can set up. So, I guess its in the web.
HPW7V64 is my machine name.
The database that I am trying to connect to is on my machine on the server HPW7V64\SQLEXPRESS.
Hope I explained it correctly. I think I might be able to get the IP Address... I will try.
theLizardPosted Mar 5, 2010, 12:46 AM
Where is hpw7v64.ggamvpn.gbridge.net\SQLEXPRESS located, is it an internal VPN or external via WEB?
Is the database on a server with a dedicated IP address? If sou you could possibly replace servername with the IP address!
GustavoPosted Mar 5, 2010, 12:45 AM
I checked your link. It shows how to check the VPN but not how to connect thru a VPN to a specific server. Thanks anyways.
GustavoPosted Mar 5, 2010, 12:39 AM
Yes, I have looked at connectstrings.com. It has samples like HPW7V64\SQLEXPRESS but not with the hpw7v64.ggamvpn.gbridge.net\SQLEXPRESS, which I tried and it did not work.
theLizardPosted Mar 5, 2010, 12:29 AM
What is TestConnection?
Have you checked out connectionstrings.com they have connection strings for just about everything.
Lalit MPosted Mar 5, 2010, 12:29 AM