Try Telnet or FTP from the workstation to the Sage 50 Connection Manager port on the server to check connectivity.

Will do so and see what it does.

Thanks!

Telnet Fails, and FTP says waiting for welcome message.... i'm not sure if this means it's working or not.  I know for a fact my firewall policy is allowing all traffic to/from the colo so it shouldn't be a policy issue.  

Telnet message is: .NEThServer Encountered an internal error.  To get more info turn on the customer Errors in the servers config file

That sounds like it connected, but didn't know what to say which is normal.  So there's at least IP connectivity from the client to the the Connection Manager listening port. 

Sage 50 parses out the server name from the path of the file.  In case the name isn't reliably resolved to the correct IP address, it might be more reliable to put IP address and sharename in the command line, with the executable path quoted:

"C:\Program Files (x86)\Sage 50 Quantum Accounting Version 2017\Sage50Accounting.exe" \\192.168.0.242\sadata\MyCompany.SAI

There are log files in the company data's .SAJ folder on the target server that can help sort out what happened if it only sort-of connects.

That sounds like it connected, but didn't know what to say which is normal.  So there's at least IP connectivity from the client to the the Connection Manager listening port. 

Sage 50 parses out the server name from the path of the file.  In case the name isn't reliably resolved to the correct IP address, it might be more reliable to put IP address and sharename in the command line, with the executable path quoted:

"C:\Program Files (x86)\Sage 50 Quantum Accounting Version 2017\Sage50Accounting.exe" \\192.168.0.242\sadata\MyCompany.SAI

There are log files in the company data's .SAJ folder on the target server that can help sort out what happened if it only sort-of connects.

It didn't really spit out any specific info in the log and it isn't logging for today when attempting to open the company.

This is furstrating, and extremely dumb.  I'm going to try getting my user to copy the data to a new location and see if that helps.

Try running the sample file as well.  It is local so it will help you determine if the problem is network related, firewall related or company file related (latter not likely).

The crummy part is that if they run the company locally it's fine.  So i know it's not the application.  I'm waiting on them to migrate the files to a new share and see how it works.

New location same error.  Says "the sage50 connection manager is not installed on the machine that hosts your data"... but i can 100% say that it is installed and at the latest version.  this is mind boggling.