Connection to SQL server 2005

Question

Connection to SQL server 2005

SQLQuest29

SSCrazy Eights

Points: 8264
More actions
April 22, 2009 at 9:59 am

#133083

Hi All,
This is a simple thing, but is bugging me a lot :hehe:
This is my problem:
I have a SQL 2005 test server. I have a login: abc with password: abc1
I have a SQL 2005 Prod server. I have a login: xyz with password: xyz1
So both my servers have SQL authentication.
For connection to Prod server, I need a VPN connection.
When I connect to SQL 2005 Test server through my SSMS(installed on my local machine), it is connected.
When I start my VPN connection, and use the same SSMS (installed on my local machine) to connect to Prod server, it is connected.
Now when I try to open a query, the connection to TEST is lost and the connection dialog is displayed indicating it is trying to reconnect.
Trying individally, both works and I am able to query the database !!
Does anybody have experienced such problem ?
Thanks,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂
November 16, 2016 at 2:51 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

dmc-608719 SSCarpal Tunnel Points: 4663 More actions · Answer 1

You may have an issue with your VPN setup. Kind of hard to tell without knowing more about your setup. Can you ping your test server, telnet, or get any other connection... or is it just SQL?

My assumption is that after you connect with the VPN your local network is unavailable. If the connection is using the remotes gateway then you will probably lose your connection as I assume the Produciton server environment does not know how to route back to your machine. In most VPN clients like CISCO you can disable using the remote vpns gateway for traffic, so that it will still use your local gateway and allow you on your internal network. I would look at that configuration setting.

Jeffrey Williams SSC Guru Points: 90252 More actions · Answer 2

Once you connect to your VPN - your test server is no longer accessible.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Ale Pelc SSCrazy Points: 2421 More actions · Answer 3

DMC is right, when you connect to the VPN then your default gateway don't know how to route you to the test environment. I suggest you use something like "route add" from command line after you connect to the VPN to add a route to your test server using the default gateway you have prior to connect to the VPN

Alejandro Pelc

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 4

dmc (4/22/2009)
You may have an issue with your VPN setup. Kind of hard to tell without knowing more about your setup. Can you ping your test server, telnet, or get any other connection... or is it just SQL?
My assumption is that after you connect with the VPN your local network is unavailable. If the connection is using the remotes gateway then you will probably lose your connection as I assume the Produciton server environment does not know how to route back to your machine. In most VPN clients like CISCO you can disable using the remote vpns gateway for traffic, so that it will still use your local gateway and allow you on your internal network. I would look at that configuration setting.

HI,

Thanks for your answer. I have a CISCO client installed on my local machine.

How can I disable using the remote vpns gateway for traffic to be able to use my local gateway and allow me on my internal n/w.

Is there any option to disable ? Can you provide some more info.

For CISCO VPN client (4.8.01.0300), I have group authentication selected, On transport tab: I have Enable Transparent tunnelling, IPSec over UDP and allow LAN access was unchecked (I checked it, but still not able to connect to TEST server once the VPN client is connected)

Also, when the VPN client is connected, I cannot ping my test server !!

Please help to solve the issue !!

Thanks,

\\K

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂