Problem with SQL forwarding. Please help!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Problem with SQL forwarding. Please help!

Problem with SQL forwarding. Please help!

Rate Topic

Display Mode

Topic Options

Author

Message

tai-847607

Posted Wednesday, February 27, 2013 1:54 PM

Forum Newbie

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

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

Post #1424737

« Prev Topic | Next Topic »

Permissions