Member Avatar for ciki022
ciki022 0 Newbie Poster

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 or
2. L2 VPN router or
3. One separate computer with microtic, and access thru him

Question is, is there any other way to establish two connections to MSSQL server 2000 remotely, without any expences ?

Regards,

Goran

  • 1 Contributor
  • 0 Replies
  • 31 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.