For Sage 300 CRE deployments, depending on the amount of users that your customer will have - we recommend different deployments. For small customers (~5 users), we can use a single server to host the data as well as run the client. For larger customers, we will deploy a data server, and then the appropriate amount of application (terminal) servers to support the user sessions. We can accommodate user growth by just simply adding additional application servers as the user count rises. 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.
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
For Sage 300 CRE installations, the customers data must reside on the E:\data location. Please note that E:\data\customercode gets mapped as H:\ to the end users. Some of our partners install the data under the customercode folder, while others prefer to put it up one level so it is not visible in the drive mapping. The partner can still share the folder out and make it accessible for only certain users.
Example: As the admin user, I have configured my Sage sample data to live at E:\data\Sage, and then shared the folder out as Sage (with the correct Sage permissions on the share). From there, I added that UNC path within Sage 300 CRE.
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. E:\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, E:\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. E:\ftp\companycode\
All of the data stored in all of these locations will take up space on the customers billable data drive. Our default Sage 100 Contractor builds have 20GB of disk space, but this can be increased by contacting sales. Please note, that we can expand data drives, but not shrink them.
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. By default, when adding a new company, Sage will create a Share so that users can access that companies files. 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. Upon a standard Sage 300 CRE install, the following shares are created automatically.
If you have a need for a SQL instance, let us know when ordering the server and we can preinstall an instance for you. If this is done, a SA user created for you to access the server as sysadmin. The password is in a text file on the server, located in C:\Software\SA Password.txt.
The first step to upgrading Sage 300 CRE to a newer version is to reach out to us, and ask us to snapshot the server. This way if at any point during or after the upgrade process there is a failure, we can roll back to the pre-upgrade image. Once we confirm we've snapshotted the server, just simply login to the customers server using administrative access (https://manage.swizznet.com and use the gear icon to connect) and run the software update.
We back up the entire E:\ drive nightly, with the exception of E:\Program Files. We keep these backups for 30 days. So, if you keep the default maintenance plan, you will effectively have 44 days of nightly backups to revert to. If you keep only a week, you will have 37 days.
View a webinar recording of these items: