Sage 100

Our client is in a hosted environment, where the network server(s) are hosted by their IT Network Professionals.  We are experiencing some issues, and it recently came to light that a number of users are utilizing Sage 100 Premium Workstations, from a PC local installation.  They are not using a Terminal Server and a published application.  Call me silly, but is this a good idea to install the workstation directly on the individual user's PC while the server is in a cloud environment?   Isn't performance best when the user either has a Terminal Server Desktop, or a Terminal Server Application?  Your thoughts?

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Unless they have dedicated / guaranteed bandwidth and have ping speeds less than 30 ms it will be slow and most likely unusable.  Printing will be an issue and the c/s odbc print service will need to be installed. Crystal reports runs on the workstation requiring data to be passed over the network.  Unless there is guaranteed bandwidth with ping speeds in the low twenties, the network traffic will quickly become a bottleneck, particularly when you start adding users.... Yes, terminal server or Citrix, unless they want to pay big bucks for network bandwidth and speed.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Can you elaborate on what some issues entail? 

I have customers who've tried this and insist it will work. They typically have problems with printing speed ( sometimes minimized with C/S ODBC ), speed of workstation setup, speed of workstation sync, various speed issues with anything print/saving to PDF.

I just tell them that it's not advisable to run the client straight over the Internet and typically it's 3 to 6 months for the true non-believers to become believers and we convert them to a true remote setup.

I'm sure there are people who run strictly over an Internet connection but I don't get tied up in debugging the many hardware or Internet issues which can arise and I tell them that right up front.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

@Wayne Schulz, they are adopted.  Having tons of problems with network slowdowns mid day, that may be related to one of many things.  Third party add on products, random SQL scripts running at key times, large processing of data happening during the slow down, etc.  We just realized they are using Sage 100 installed locally on the PC, and can't figure out "why".

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 09-04-2019 08:28
From: Wayne Schulz
Subject: Best Practices

Can you elaborate on what some issues entail?

I have customers who've tried this and insist it will work. They typically have problems with printing speed ( sometimes minimized with C/S ODBC ), speed of workstation setup, speed of workstation sync, various speed issues with anything print/saving to PDF.

I just tell them that it's not advisable to run the client straight over the Internet and typically it's 3 to 6 months for the true non-believers to become believers and we convert them to a true remote setup.

I'm sure there are people who run strictly over an Internet connection but I don't get tied up in debugging the many hardware or Internet issues which can arise and I tell them that right up front.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

Page 6 on the SPM has notes on speed / minimum requirements for running the client remotely... but in our experience it is simply too slow / with more connection issues.
(Note: CS-ODBC does not apply to Premium / SQL).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

I will simply echo what everyone is saying in support. 
I do not recommend running the Sage client over the WAN.  
There are a couple of possible exceptions, but they are pretty expensive and labor-intensive. The best way would be to connect to an RDP /RemoteApp session in the same LAN as the Terminal Server/Citrix, etc...

------------------------------
George Khairallah
CTO | gotomyerp, LLC
george.k@gotomyerp.com | 877-888-5525
http://gotomyerp.com/
------------------------------