Sage 300 ERP Best Practices in Cloud Workspace

This Knowledge Base article will simply cover how the program is set up, where the data is stored, what Swizznet is backing up, and what you need to do as the partner. 

Administrative Access

When you log in to the server using the management portal (https://manage.swizznet.com), you are accessing the server as a local administrative user. You will have full admin rights to the server(s) for that customer. You should 

Installation

Sage 300 ERP should be installed to the default location on the C:\ drive. The data should be stored at: C:\data\COMPANYCODE\Sage with all the proper permissions configured as per Sage's system requirements. 

*If you are going to use Sage 300 CRM, you will want to configure a service user to run the integration service. If you use your domain account, when your password expires - the service will fail.

Mapped Drives

We map folders out as drive letters for the customers, where as the Admin users (partners) will not see them the same way. Here is a list of our default mapped drives, and what their purpose is. 

Z:\ - Within Cloud Workspace, every user will get a personal drive that is only visible to them. This can be used to store private documents, etc. C:\pro\companycode\username

H:\ - This mapped drive is the shared data location for the server. All users will have access to this, and this is a place to store common folders, documents that all of the users must access, etc. The physical location of this share is, C:\data\companycode\

F:\ This mapped drive is the location where data uploaded via FTP will be stored. Typically this would be used during the migration period. C:\ftp\companycode\

*Our default Sage 300 ERP builds have 100GB of disk space, but this can be increased by contacting sales. Please note, that we can expand data drives, but not shrink them. 

Shares

You can create shares as needed on the server. We understand that customers needs vary and that some of your users may be used to browsing through the company files, where as some may not be technical enough to do so. Please note, if you create a share, ensure that Everyone is given Full Control on the Share permissions as well as the Security permissions. This is required by Sage and should be used in most circumstances.

Accessing SQL

If you have requested SQL, we will have an SA user created within SQL for you to access the server. The password is in a text file on the server, located in C:\Software\SA Password.txt. This will allow you in as SA. You can manage the customer using this login, or grant yourself sysadmin rights within SQL Sever Management Studio/Sage Database Administrator. We already have Knowledge Base Articles for adding admin users, as well as normal Sage users. Those are linked below.

Adding Sage Company Administrators

Adding Sage Users 

Backups

Our backups run nightly and retain 30 days of data. In order for your user documents/data as well as Sage data to be backed up, please ensure it is in the following directories:

 

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.