Sage 50 Company Files on Separate Servers

darylkrause
darylkrause used Ask the Experts™
on
I have a client running a Server 2012 STD server as domain controller and remote desktop server.   On that same server, they have Sage 50 US installed and hosting 4 Sage company files accessible via the local network workstations and through remote desktop services.    We now have a need to isolate one of these company files.   My thought is simply to install another 2012 or 2016 Standard server and to install Sage 50 on that box for that single company.   I'm assuming local workstations could still access that file through a different drive mapping.   Is that correct?   Would I need all new RDP licensing to keep users of this lone company ONLY on this new server when accessing it remotely?

Any other solutions anyone can think of?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill BachPresident and Btrieve Guru

Commented:
Each Sage 50 installation would come with the Sage 50 software AND the PSQL database engine license to run that software.  I do not know for sure if Sage allows you to install their license onto multiple servers, or if you would have to pay another license fee for that, so contacting them is the best way to know for sure.  

Licensing aside, the PSQL database engine works solely from the application's perspective.  It is up to the application to provide the path to the database files to the PSQL Client, which then handles finding the right server and contacting that server for database services.  This should make it a simple matter of changing the drive letter or UNC path used by Sage.  As long as it resolves to the new server (and the firewall doesn't block access to TCP ports 1583 and 3351), then you should be contacting the new server directly.  If Sage provides the PSQL Monitor tool, then you should be able to see the users connecting to the server within that GUI interface.  If not, perhaps they provide BMON, a Java-based alternative that runs from a command line.  If they don't provide even that tool, then try the third party PSConfig tool.  With that tool, a simple command line "PSCONFIG /M*" run from the database server will show you all you need to know about what is going on inside the PSQL engine,

For true separation, you'll need to have RDP licenses available on the second server, too.  Note, though, that you could have users from BOTH systems on a third server running RDP services and accessing either server, which might save in licensing costs.

Author

Commented:
Thank you for your response!   That last paragraph helped more than you can know.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial