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 |
|
shifad53
Starting Member
1 Post |
 Posted - 2011-07-12 : 07:51:00
|
| Im sorry if ive posted it in the wrong forum..First let me tell the scenario..I have developed a windows application for my company. It is a multi user software and we are using sql 2008 as the database. The sql 2008 is installed in our company server. Within our LAN, there is no problem in accessing the software and its working pretty fine. Now the problem is, some of the managers need to go out frequently(for business tour and all) and they need access to this software. The software is already installed in their laptops.Is there any way to access the database that is in our company server ???We have few static IPs with us, is there any way i can use that here (Using NAT in the firewall or something)???Pls help guys, its very urgent. |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2011-07-12 : 09:11:28
|
| In theory, yes you could do something like this, but this would require somebody with good knowledge of networking as well as security. If you are going down that path, then I would strongly recommend creating a VPN network. This would practically eliminate the need to open up any kind of ports on firewall and risk exposing your network to hackers, malware, etc. When your users dial into your VPN, they basically join the network as if they are physically in the office and therefore have access to all local resources, including your database servers. Also, a good VPN setup will guarantee encryption of data both ways, whereas simply opening up a port on your firewall will very likely lead you to data exchanged in plain text and therefore prone to sniffer/man-in-the-middle attacks.OS |
 |
|
|
|
|
|
|
|
connecting database from outside the LAN