0

I would like to know if there are some type of applications that allows me to access SQL Server in my local server remotely from a desktop application in one of my other branches through Internet;

I've already read about accessing it by using public IP; but that is too difficulty for me as I cant get public IP for my server easily. Plus I cant get access to the routers to set ports required;

Are there are other applications (even paid ones) that provide some sort of tunnels to access my SQL Server database remotely?

James Z
  • 12,209
  • 10
  • 24
  • 44
Mohamed Nor
  • 583
  • 1
  • 7
  • 12

1 Answers1

1

You're not looking for a Sql Server solution here. Any generic correctly configured VPN solution will work. However that is not in and of itself an easy configuration and, depending on your business, your security department may expressly forbid.

Your best bet is to use some sort of Desktop sharing solution TBH, e.g. Splashtop, TeamViewer etc. Again, your security department may not be too happy with such a 'solution' either.

Rachel Ambler
  • 1,440
  • 12
  • 23
  • Thanks @Rachel ; but Desktop sharing solution is not Possible as i want to add transactions to my SQL server database form Desktop App located in an other branch through internet. ; For Now the Security is a priority as i am running simple Order Application. – Mohamed Nor Jun 04 '17 at 16:32
  • So if You Know any VPN app that allows me to execute Queries directly Against my Database ?? – Mohamed Nor Jun 04 '17 at 16:36
  • Pretty much all correctly configured VPN solutions will allow you to do that. That said, asking to suggest or for recommendations on various VPN solutions is not the remit for Stack Overflow, as that then comes down to opinion and not fact. In addition they're not usually things you can set up on the fly. If you have a security department then you can bet your bottom dollar they'll be VERY involved in anything you try to do that'll potentially 'punch a hole' through whatever firewall protections they have configured. – Rachel Ambler Jun 04 '17 at 17:03
  • You should bring this up to your manager\boss and your security department next. – Rachel Ambler Jun 04 '17 at 17:06