Connection String to Server

Question

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?

theLizard · Answer

I would be very concerned about security, the service suggests that you have a fixed IP address to your ISP, is this correct? 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.

Lalit M · Answer

for information try this link VPN connection using c# code

theLizard · Answer

Ok, good luck.

Gustavo · Answer

I am just going to use the main server HPW7V64 remotely. Its too much of a pain for now. I can use the virtual machines for the other remote servers. 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.

Gustavo · Answer

Lizard: 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.

theLizard · Answer

I have had a look at GBridge and my first impression is that i would be very dubious of using their services but that is my opinion only. 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...

Gustavo · Answer

Lizard: 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=***********;";

theLizard · Answer

Let me check out GBridge, but if the DB is on your machine you should be able to connect to it direct. What version of sql are we talking about? What provider are you using to connect?

Gustavo · Answer

Lizard: 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.

theLizard · Answer

To better help you, 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!

Gustavo · Answer

Lalit: 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.

Gustavo · Answer

Lizard: 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.

theLizard · Answer

I do not think it matters how many servers you have on your machine as long as the connection strings refer to the server you are trying to connect to it will connect. What is TestConnection? Have you checked out connectionstrings.com they have connection strings for just about everything.

Connection String to Server

Answers (13)