We help IT Professionals succeed at work.

How can I use server applications through VPN on my laptop

542 Views
Last Modified: 2013-12-11
I use a laptop at work and use a few database driven applications at work on my laptop.
I have VPN access from home via a sonicwall remote vpn client on my laptop.
I am able to connect to the network via vpn but I am unable to connect to the network applications. What do I need to do to be able to connect?
Comment
Watch Question

Tekati68Information Technology Director

Commented:
You need to give us more information here.  By the Zones you entered I will assume you want to use Microsoft Dynamics which is a SQL intensive program so chances are we can get it to work for you but you are not going to be happy with the speed.  It will be considerably slower unless you have a really great connection.  Using a Terminal Server and Remote Client for that application will help a great deal.

Now with that.  You say you can connect and VPN works fine so my next question would be how are you connecting to the database with the Dynamics client on your laptop?  Are you using a hostname that translates to an IP address properly?

Is the Dynamics client using TCP for the protocol to speak to the SQL server?

There are lots and lots of things that can be causing this to happen.  I have covered just a couple of gotcha's out of 100's or even 1000's of possible reasons.

You need to explain in great detail what is happening.

For instance...

When I am at work and plugged in to the local network there the program opens and works fine...
At home over the VPN client I open the program and I get XXXXX error?

Be detailed and we will try to get you going.
Victoria YudinOwner / Dynamics GP Consultant
CERTIFIED EXPERT

Commented:
I cannot speak for every database application, as some may be different.  However, the recommendation for Microsoft Dynamics GP it to set up either a Terminal Server or a Citrix server for any users that need to connect in remotely.  If it's just for one user and there is an available desktop computer in the office, you can install GP on it and connect to that computer remotely from home, using the SonicWALL VPN connection.  If it's more that one user, then I would go with Terminal Server.

Author

Commented:
At work on the lan I can use the applications installed on my laptop just fine but at home on the VPN no luck.
On Great Plains it gives me a place to sign in, but then it says Great Plains is not responding and it
never logs in.
On FRx it just simply want let me login at all.
This is the error I get for FRx.

Frx Sysdata locations is not valid. Make sure the Sysdata location in your
FRx Config.xml file (C:\users\mark\AppData\Local\FRxSoftware\FRx 6.7\FRx
Config.xml) is a valid path & that you have permission to read & modify
files in the Sysdata folder.

Would a simple fix be to setup a remote access server on the lan with some terminal server licenses then load the apps on that server so users can remotely log in to the network then use a generic desktop with all apps available? would this be a pretty straight forward setup as I mentioned here?

Victoria YudinOwner / Dynamics GP Consultant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Information Technology Director
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I am going to install TS on server 2008 App server, this server runs most of our cad programs running solid works but with 16Gb ram and dual quad cores should nto be a problem.

Thank you both, any primers you could direct me to for TS install and app configs before I award points?
Victoria YudinOwner / Dynamics GP Consultant
CERTIFIED EXPERT

Commented:
Make sure to install both GP and FRx as the local administrator to avoid issues.  Here is a GP KB article that talks about some additional guidelines for installing on a TS: https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;872242 (you will need a CustomerSource login to access this).  


 
Tekati68Information Technology Director

Commented:
There are a ton of how to's online for configuring TS on a Windows Server 2008 machine.  There really arent a lot of gotcha's that you need to know about.  Once installed it acts just like Remote Desktop except it allows for multiple people to be logged in at the same time in their own workspace.  You will need to pay attention to the licensing for your server but this sounds like a server that is already doing work for you so adding Terminal Services will be a snap as long as you have the licenses to go along with it.  Worst case you have to purchase a few more licenses to make it all work.  That server sounds beefy but it sounds like you are running some pretty intensive stuff on it already.  My suggestion would be to try it and see how it goes.  I am sure it will be fine just like you were thinking.

Good luck and always feel free to ask more questions if you run in to any issues.

Author

Commented:
I have order 10 cals from CDW.
Tekati68Information Technology Director

Commented:
Sounds like you have it all under control.  

Good luck and like I said feel free to ask if you run in to anything.

Author

Commented:
SLAM DUNK! Order 10 cals and install TS licensing, sweet!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.