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