Sage 100

I have a client that has Sage 100 2021 Advanced on a physical server.  I have told their IT company they need a remote server set up for people not on site.  The IT company has proposed a hosted server for the workstation client, without knowing anything about Sage 100.  I have clients on a hosted server that Sage is installed on and Clients where everyone accesses Sage 100 from a terminal or Citrix server.  I do not have a situation where Sage 100 would be on a physical server and workstation access on a hosted server.  Does anyone know if this works?

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

The Sage server and the machine running the Sage client software (terminal server or workstation) should be on the same physical network with no WAN link. 
There are details in the SPM for Advanced / Premium for speed of network connections between client and server, but local wired networks are best (no VPN / WAN / wireless... between Sage server and client).

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

Host and Hosted - I find these terms are tossed around without context. The big question is where will the host reside? Hosts can be located on and off premises. If the host is on the same LAN as the physical server (Sage 100 Adv) and the host has multiple virtual servers or workstations, should be no issues. If the host is located off premises, it would very create problems. As Ken points out, the real question is what is the nature of the link between the Sage 100 workstation (client) and the server.


------------------------------
Myron Stevenson
Consultant
Clearis Consulting, Inc
Duluth, MN
218-525-6720
------------------------------

I have the same situation come up. The customer's IT wants to offload the server ( Sage 100 2018 Premium ) to Azure and then have people connect using a WAN. They initially contacted me ( IT people ) a while ago and I advised why this was not a great idea. They went ahead and did it and contacted me this week about why Sage was so slow. I advised them the same that the standard way to access a remote server is via some type of RDP. 

They went and Google'd and found the C/S ODBC and want to know if that will cure any issues.

I continue to advise against it and if they require more handholding down the road after disregarding my advice I probably will have a conversation about whether such help is outside the scope of my access agreement.

All of this is par for the course these days. 

The real learning item for consultants is to always cover the things that the customer is going to go out and find by Google search, Sage City and then what Sage support is likely to suggest to them. We really need to think several steps ahead and presume the customer likely already has done a fair amount of searching so the best defense is a good offense in these cases meaning we need to cover in detail the pros/cons of these issues.

Where I have more than just one customer repeatedly asking the question I develop an FAQ so I don't have to keep writing mini-novels in response to their questions. I did this for Sage 100 Premium after more than one customer pressed me for exact requirements and why they shouldn't just buy SQL runtime from Sage. 

P.S. - The customer doesn't read or believe most of the info you provide them. I recognize this and have mainly used the info as cover when their own odyssey of self-implementation backfires.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

The SPM has some numbers to have their IT validate that it is a bad idea... WAN links don't have "guaranteed minimum bandwidth", with vastly inconsistent ping times.

• 
• 

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

Original Message:
Sent: 03-11-2022 12:23
From: Wayne Schulz
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

I have the same situation come up. The customer's IT wants to offload the server ( Sage 100 2018 Premium ) to Azure and then have people connect using a WAN. They initially contacted me ( IT people ) a while ago and I advised why this was not a great idea. They went ahead and did it and contacted me this week about why Sage was so slow. I advised them the same that the standard way to access a remote server is via some type of RDP.

They went and Google'd and found the C/S ODBC and want to know if that will cure any issues.

I continue to advise against it and if they require more handholding down the road after disregarding my advice I probably will have a conversation about whether such help is outside the scope of my access agreement.

All of this is par for the course these days.

The real learning item for consultants is to always cover the things that the customer is going to go out and find by Google search, Sage City and then what Sage support is likely to suggest to them. We really need to think several steps ahead and presume the customer likely already has done a fair amount of searching so the best defense is a good offense in these cases meaning we need to cover in detail the pros/cons of these issues.

Where I have more than just one customer repeatedly asking the question I develop an FAQ so I don't have to keep writing mini-novels in response to their questions. I did this for Sage 100 Premium after more than one customer pressed me for exact requirements and why they shouldn't just buy SQL runtime from Sage.

P.S. - The customer doesn't read or believe most of the info you provide them. I recognize this and have mainly used the info as cover when their own odyssey of self-implementation backfires.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

Thank you for the information.  This was going to be an external hosted server.  I was on a meeting with the IT people and shot their idea down.

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------

Original Message:
Sent: 03-11-2022 12:34
From: Kevin Moyes
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

The SPM has some numbers to have their IT validate that it is a bad idea... WAN links don't have "guaranteed minimum bandwidth", with vastly inconsistent ping times.

• 
• 

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


Original Message:
Sent: 03-11-2022 12:23
From: Wayne Schulz
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

I have the same situation come up. The customer's IT wants to offload the server ( Sage 100 2018 Premium ) to Azure and then have people connect using a WAN. They initially contacted me ( IT people ) a while ago and I advised why this was not a great idea. They went ahead and did it and contacted me this week about why Sage was so slow. I advised them the same that the standard way to access a remote server is via some type of RDP.

They went and Google'd and found the C/S ODBC and want to know if that will cure any issues.

I continue to advise against it and if they require more handholding down the road after disregarding my advice I probably will have a conversation about whether such help is outside the scope of my access agreement.

All of this is par for the course these days.

The real learning item for consultants is to always cover the things that the customer is going to go out and find by Google search, Sage City and then what Sage support is likely to suggest to them. We really need to think several steps ahead and presume the customer likely already has done a fair amount of searching so the best defense is a good offense in these cases meaning we need to cover in detail the pros/cons of these issues.

Where I have more than just one customer repeatedly asking the question I develop an FAQ so I don't have to keep writing mini-novels in response to their questions. I did this for Sage 100 Premium after more than one customer pressed me for exact requirements and why they shouldn't just buy SQL runtime from Sage.

P.S. - The customer doesn't read or believe most of the info you provide them. I recognize this and have mainly used the info as cover when their own odyssey of self-implementation backfires.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT

Good to hear, Michele!

Increasingly we run into IT groups who only have experience with web browser-based apps in remote servers. Those who were experts with Terminal Server seem to be receding. Hence, their confusion over sluggish performance. Hence, our need to educate them. 

I also remind all that CEOs/CFOs have no mechanism to help them determine when their IT lead is incompetent ...  

------------------------------
Jerry Norman
At-Large BOD Member, 90 Minds
Smartbridge Partners
------------------------------

Original Message:
Sent: 03-11-2022 13:22
From: Michele Herzog
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

Thank you for the information.  This was going to be an external hosted server.  I was on a meeting with the IT people and shot their idea down.

------------------------------
[Michele] [Herzog] [CPA,CITP, CGMA]
[Overland Park] [KS]
[816-520-1365]
------------------------------


Original Message:
Sent: 03-11-2022 12:34
From: Kevin Moyes
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

The SPM has some numbers to have their IT validate that it is a bad idea... WAN links don't have "guaranteed minimum bandwidth", with vastly inconsistent ping times.

• 
• 

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


Original Message:
Sent: 03-11-2022 12:23
From: Wayne Schulz
Subject: Sage 100 on a Physical Server - Workstation Access from a Hosted Server?

I have the same situation come up. The customer's IT wants to offload the server ( Sage 100 2018 Premium ) to Azure and then have people connect using a WAN. They initially contacted me ( IT people ) a while ago and I advised why this was not a great idea. They went ahead and did it and contacted me this week about why Sage was so slow. I advised them the same that the standard way to access a remote server is via some type of RDP.

They went and Google'd and found the C/S ODBC and want to know if that will cure any issues.

I continue to advise against it and if they require more handholding down the road after disregarding my advice I probably will have a conversation about whether such help is outside the scope of my access agreement.

All of this is par for the course these days.

The real learning item for consultants is to always cover the things that the customer is going to go out and find by Google search, Sage City and then what Sage support is likely to suggest to them. We really need to think several steps ahead and presume the customer likely already has done a fair amount of searching so the best defense is a good offense in these cases meaning we need to cover in detail the pros/cons of these issues.

Where I have more than just one customer repeatedly asking the question I develop an FAQ so I don't have to keep writing mini-novels in response to their questions. I did this for Sage 100 Premium after more than one customer pressed me for exact requirements and why they shouldn't just buy SQL runtime from Sage.

P.S. - The customer doesn't read or believe most of the info you provide them. I recognize this and have mainly used the info as cover when their own odyssey of self-implementation backfires.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT