Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ciki022
Starting Member
6 Posts |
 Posted - 2009-06-03 : 07:24:54
|
| Hi and greetings to all members,I have MSSQL server 2000 instaled on XP SP2, and I am accessing him over internet and VPN connection, router and ADSL operational, and it works well.Now I added, on remote side, another computer, conected to LAN with first one, and I want to simultaneously connect with both computers to MSSQL server, but that is not possiblle with second, because, when VPN connection is active from first one, error says that OS cannot make multiple connections ( VPN ).Ok, I tried to connect direct to MSSQL server, thru 1433 ports, opened on router, but that simply doesnt work.My colleague administrator from another enterprise, has told me next ( for answer my multiple ( 2 ) connection need ):1. Windows Server - for multiple VPN connections or2. L2 VPN router or3. One separate computer with microtic, and access thru himQuestion is, is there any other way to establish two connections to MSSQL server 2000 remotely ? Regards,Goran |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-06-04 : 13:11:50
|
| Yes, this will be much easier if you add the VPN to the router at the remote site.Or use VPN software other than what is included with windows.]An alternate solution, would be for you to remote into a workstation that is local on that network. Which will be able to access every machine local to it.Depending on your purposes. |
 |
|
|
ciki022
Starting Member
6 Posts |
Posted - 2009-06-05 : 02:55:50
|
| Thanks You for your answer.1. "Yes, this will be much easier if you add the VPN to the router at the remote site." I dont undestrand, can You explain ?2. I tried to use Winsshd and Tunnelier software to make some kind of VPN tunnel thru SSH protocol, and I succeed only to make telnet and FTP protocols running, but access to MSSQL not.Can You explain what kind of software I should use and how to adjust the settings in order to work access to MSSQL server ?3. Remote access into one of my workstation is not good solution, because I have need to print from application in which I am working to access MSSQL server.I wopuld appreciate Your further suggestions. |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-06-08 : 10:42:37
|
| 1. You setup the VPN Connection in the target servers network (in thier router), instead of going directly from PC to PC. That will allow you to connect to thier entire network. Most business routers (cisco sonicall fortigate etc. will allow this) You will have the ability to connect to any machine or device on that network. (and the access is totally programmable)2. Cant help you there. Try gotomypc?3. Remote desktop software, you can install your printers @ home on the target machine. That will allow you to print. (this is dependant on the type of printer your using at home to ensure there are drivers for a server operating system.) Your best bet would be to use a hp laserjet. Older the better. LaserJet4000 works on every machine ive ever tried. |
|
|
|
|
|
|
|
|
MSSQL server remote access over VPN and direct