Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problem with SQL forwarding. Please help! Expand / Collapse
Posted Wednesday, February 27, 2013 1:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 1, 2013 9:22 AM
Points: 1, Visits: 7

I am setting up a central vpn server to redirect different sql connection to different database. Here is what i am dealing with

1) different SQL 2005 servers on different networks

2) a central vpn server to redirect all traffics to correct server. This is a vpn server and it has Sql Server Configuration Manager installed (no actual sql server). So i set up alias for different connection such as GoldA go to db A of server A, GoldB go to dbB of server B. TCP/IP protocol are enabled. If I use SQL server Management Studio on this machine, i can connect to all alias and connect the correct databases

Now the problem is: if a client machine establish a vpn connection and then connect to <vpn server local ip>\GoldA to access to his db, it does not connect at all. It returns error message "The server was not found or was not accessible. error: 26- Error Locating server/Instance)"

What do I need to do toget this working?

Thanks for your help

Post #1424737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse