Problem with SQL forwarding. Please help!

• tai-847607

  Newbie

  Points: 1

  More actions

  February 27, 2013 at 1:54 pm

  #274583

  Hi,

  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