Installing Sage 100 Premium

Read this guide completely before installing and setting up Sage 100 Premium. A series of procedures must be completed for new installations. For more information, read the Getting Started Guide, which is available in the Documentation folder within the Sage 100 installation program.

When upgrading a system, there are additional pre- and post-installation instructions for converting to the current version. For more information, read the Customer Upgrade Guide. To access this guide, select a product from the Autorun screen, and then click Documentation on the product screen.

Installation Requirements

Microsoft SQL Server must be installed before installing Sage 100 Premium. Sage supports the installation of Sage 100 Premium and Microsoft SQL Server on the same server as well as the installation of the two products on separate servers. For information on the version of Microsoft SQL Server available through Sage, see Microsoft SQL Server Runtime Edition.

Sage 100 Premium uses the TCP/IP protocol for all communications between the workstation and server. To run Sage 100 Premium, TCP/IP must be properly configured on both the Windows Server and all workstations that will run Sage 100 Premium on the server. For more information, see TCP/IP Protocol.

If you are installing Sage 100 Premium on a Windows Server with Terminal Services enabled, see Remote Desktop Services Considerations.

For a complete list of system requirements, refer to the Supported Platform Matrix. To access the matrix, see article ID 47649 in the Sage Knowledgebase.

All prerequisites must be installed before installing Sage 100 Premium; any prerequisite that is not on your system will be installed by the Sage 100 2021 installation program.

Important! If you are upgrading from a prior version, you must install Sage 100 version 2021 to a new location and perform a parallel installation.

Microsoft SQL Server Runtime Edition

If you purchased SQL Server directly from Sage, you will install Microsoft SQL Server Runtime Edition. The only difference between this version and the standard edition of SQL Server is that Microsoft SQL Server Runtime Edition can be used only with Sage products. The performance of the two versions is the same, both come with the same database administration tools, and neither have restrictions on the database size.

SQL Server Installation Types

There are two installation types available: Sage Configured and Advanced. The Sage Configured option allows you to bypass the Microsoft SQL Server Setup program; SQL Server is automatically optimally configured for Sage 100 Premium.

For information on how parameters are defined, see Sage Configured Installation for SQL Server.

If you select the Advanced installation option, you will exit the Sage installation wizard. The Microsoft SQL Server Setup program’s Autorun screen appears, and you can use that program to configure and install SQL Server.

If the installation wizard detects an existing SQL Server installation, you have only the Advanced installation option.

Microsoft SQL Server Runtime Edition Installation Process

If you purchased SQL Server from Sage, follow the steps below to perform the installation.

To install SQL Server

  1. Log onto the server where SQL Server will be installed using the Administrator account.

    We strongly recommend using the Administrator account rather an account with administrator rights.

  2. Close down other programs. Do not close antivirus, antispyware, and script-blocking software unless it is actually interfering with the installation.

  3. Download the Microsoft SQL Server installation file from the location specified in your Download Notification e-mail from Sage.

    Note: Save the download file in a folder located directly beneath the root directory. For example: C:\temp.

  4. If you aren’t automatically asked to extract the installation files, click the executable file to extract them. The Microsoft SQL Server folder, which contains the installation files, will be extracted.

  5. In the Microsoft SQL Server folder, right-click Autorun.exe, and then select Run as administrator.

  6. On the Autorun screen, click Install Microsoft SQL Server Runtime Edition.

    A message appears if SQL Server is already installed on your system. The Sage Configured installation type will be unavailable; you must use the Advanced SQL Server Installation option.

    If no installation is encountered, the Sage Configured SQL Server Installation is available. This is the recommended option.

  7. Follow the steps in the installation wizard to install SQL Server. If you select the Advanced SQL Server Installation, you will use the Microsoft SQL Server Setup program to configure and install SQL Server.

    If one or more of the required components are missing from your server, a message appears. Click Yes to install the missing components, or click No to exit the installation process.

  8. If you are asked to restart your system after components are installed, restart the computer, and then resume the installation.

Note: The SQL Server Setup window appears during the installation, which may take up to an hour.

Pre-Installation Tasks

Perform these tasks before installing Sage 100 Premium.

  • If you are upgrading from a prior version, read the Customer Upgrade Guide, which is available on the Sage 100 Documents page and in the Documentation folder within the Sage 100 installation program.

  • Verify that you have your Sage Download Notification e-mail, which includes the serial number, customer number, user key, and product key, which are required to install Sage 100 Premium for the correct number of users and to register the modules. This information is also available on the Sage Customer Portal under Products > Details.

  • Depending on your Internet connection speed, downloading the installation files may take several hours; therefore, you may want to download the files in advance. The installation files should be downloaded directly onto the server where Sage 100 will be installed.

  • Test and validate all of the hardware and network configurations using the following resources, which can be found in the Sage Knowledgebase.

    Important! If you install Sage 100 on a server with an unsupported operating system, Sage 100 Customer Support will be unable to assist you if you encounter any problems.

  • Configure TCP/IP as a protocol on your server and workstations. All workstations must be able to ping the server and the server must be able to ping all of the workstations. For information on pinging the server, see Basic Configuration.

  • Verify that the Application Server port ID is open, and create an inbound rule, if necessary.

  • Third-party applications used with Sage 100 Premium may require a drive mapping or UNC path to the server where the data files are located. This drive must be mapped to a share point on the server above the MAS90 folder. Although Sage 100 Premium itself does not require a logical drive mapping, any application written to access the data files (including third-party or Sage developer partner applications) must have a valid logon to the server and may require a logical drive mapping or UNC path.

  • If you are installing Sage CRM and using the Integrated Logon for SQL Server, create a Windows user account with permissions to access both the server where Sage 100 Premium will be installed and the SQL Server database. This account is used by the Integration Engine to send data between the Sage 100 server and the Sage CRM server. You are asked to provide this information during the Sage 100 installation. For more information see Installing Sage CRM.

Sage 100 Premium Installation Process

Run the Sage 100 Premium installation wizard to install a new instance of Sage 100 Premium or to upgrade your system from a prior version. The installation wizard guides you through the installation.

To install Sage 100 Premium

  1. Log on to the server where Sage 100 will be installed using the Administrator account. Please note:

    • We strongly recommend using the Administrator account rather an account with administrator rights.

    • You must run the Setup program on the Windows server, not from a workstation connected to the server.

    • If you plan to select the Windows authentication option when running the installation wizard, the account must be a member of the sysadmin role on the server. This is necessary to ensure that the MAS_SYSTEM SQL database is created correctly.

  2. Close down other programs. Do not close antivirus, antispyware, and script-blocking software unless it is actually interfering with the installation.

  3. Download the Sage 100 2021.exe file from the location specified in your Download Notification e-mail from Sage.

    Note: Save the download file in a folder located directly beneath the root directory. For example: C:\temp.

    The installation program must be saved on the server where you are installing Sage 100.

  4. If you aren’t automatically asked to extract the installation files, click the Sage 100 2021.exe file to extract them. The Sage 100 2021 folder, which contains the installation files, will be extracted.

  5. In the Sage 100 2021 folder, right-click Autorun.exe, and then select Run as administrator. You must start the installation program using the Autorun.exe file. Starting the program by running a different file may result in installation errors.

  6. On the Autorun screen, click Sage 100 Premium, and then click Install Sage 100 Premium to start the installation.

  7. Follow the steps in the installation wizard to install a new instance or upgrade an existing installation.

    Note: When specifying where to install Sage 100, do not nest a destination folder in folders named MAS90 or SOA.

    If you’re installing on a computer running a 64-bit version of Windows, you’ll have the option to install either the 64-bit or 32-bit version of Sage 100.

Important: 

  • If you’re installing on a computer with an earlier 32-bit version of Sage 100 installed, the 32-bit version will no longer work if you install the 64-bit version.

  • If you install the 64-bit version of Sage 100 then only workstations with the 64-bit version of Windows will be able to run Sage 100.

We recommend installing the 32-bit version, migrating your data, and then running the 32-bit/64-bit Switch Utility to convert version 2021 from 32-bit to 64-bit. For more information, see the Sage 100 2021 Upgrade Guide.

When you reach the Sage 100 Integration Engine Service screen, keep the following notes in mind:

  • If you’re integrating Sage 100 with Sage CRM, the user account that you enter must have access to run the Sage 100 Integration Engine service and also the server where Sage CRM is installed.

  • The service is disabled by default. For more information, see Installing Sage CRM.

  • The default port number is used only for the integration with Sage CRM, not for the Sage 100 Application Server.

The time required to install depends on the number of modules selected. If several modules are installed, this process may take several minutes.

If you receive a message stating that no installation of Adobe Acrobat Reader was detected, click OK to continue with the installation. To install the application, on the Sage 100 Standard screen, click Productivity Applications, and then click Install Acrobat Reader.

After the Sage 100 installation is completed, the Upgrade Checklist automatically appears if Acrobat Reader is installed. To manually access this document, click Documentation on the Sage 100 Premium screen.

Important! If a message appears asking you to restart the computer, you must do so before the installation will be fully functional.

Post-Installation Tasks

Perform the following tasks after installing Sage 100 Premium.

  1. Create a backup of the MAS90 folder created when you installed Sage 100. The backup will be useful in case you need to reverse any changes; you may be able to do so without reinstalling the product.

  2. If you are upgrading, refer to the Customer Upgrade Guide, which is available on the Sage 100 Documents page and in the Documentation folder within the Sage 100 installation program.

    Review the changes that have been made in Sage 100, and follow instructions in the upgrade checklist to migrate and convert your data.

  3. Install any Sage 100 2021 updates that are available in the Sage Knowledgebase.

  4. Create a share at least one folder above the MAS90 folder. This is required before running Workstation Setup. For more information, see Sage 100 Security Permissions .

  5. Set up and start the Application Server (see Using the Application Server).

  6. To run Microsoft Script links, you must have the Microsoft Windows Script Host processor on your system. For information on installing the Microsoft Windows Script Host processor, refer to the Microsoft Download Center Web site.

  7. Install Sage CRM if you plan to use that product (see Installing Sage CRM).

  8. Run Workstation Setup on all workstations that will access the Sage 100 Premium installation.

    For details, see Workstation Setup.

    • Workstations used to process credit card transactions or set up credit card processing require a working Internet connection.

    • Add www.sageexchange.com to the list of trusted websites for any workstations that will be using the Paya Connect Desktop to set up credit card related data.

  9. If you process credit cards or ACH payments through Paya (formerly Sage Payment Solutions), you must install Paya Connect Desktop. For more information, see Setting Up Credit Card and ACH Payment Processing.

  10. If you plan to use Sage Intelligence reporting, see Installing Sage Intelligence Reporting .

  11. Install optional productivity applications, such as SAP Crystal Reports Designer, on each workstation as needed. Installing SAP Crystal Reports Designer is necessary only if you plan to create or modify reports.

  12. If you are installing Federal and State Tax Reporting, you must install it on each Sage 100 workstation. For more information see Installing Federal and State Tax Reporting.

  13. If you're using the Payroll module, to ensure that your system can communicate with the tax calculation engine, add the following URL to your browser's trusted sites list: sap.na.sage.com

    Complete this step on all workstations that will be used to process payroll, and also on the server where Sage 100 is installed if the Process Tax Calculation on the Server check box is selected in System Configuration.

If you are upgrading from an earlier version of Sage 100, you can skip the following steps.

  1. Create companies and activate modules (see Creating and Activating Companies).

  2. Create roles and user codes, and set up system preferences (see Setting Up Roles and Users for Security).

  3. Set up the modules for your companies. If you are converting your existing business management system to Sage 100 Standard, assemble the data you need to set up each module. For more information, refer to the Getting Started Guide.

Workstation Setup

The Workstation Setup wizard installs the required software, common programs, and Help files to the workstations that will access the Sage 100 Premium installation. The workstation installation wizard copies all of the necessary Dynamic Link Libraries, ActiveX controls, and other components to the local Windows\System folder and sets up the initialization files for the workstation.

Note: Run the Workstation Setup program after every Sage 100 software upgrade.

Workstation Setup Requirements

Each workstation must have its own set of workstation components on a local hard drive. Installing Workstation Setup on the server is helpful for testing and troubleshooting, but using a server operating system as a Sage 100 workstation is not supported.

Workstations used to process credit card or ACH payment transactions or set up credit card and ACH payment processing require a working Internet connection.

Add www.sageexchange.com to the list of trusted websites for any workstations that will be using the Sage Exchange Desktop to set up credit card and ACH payment related data.

If you are running Sage 100 through Remote Desktop Services (RDS) or Citrix, do not run the workstation installation wizard directly at the Terminal Server or Citrix server. Instead, run the workstation installation wizard only once through a remote session. Running the workstation installation wizard from an RDS session will set up the correct registry entries for Crystal forms and reports access and copy the multi-user activation file from the Application Server to the Terminal or Citrix server. For more information, see Running in a Remote Desktop Services or Citrix Environment.

If you have multiple installations of the same version of Sage 100 Premium, see Multiple Installations.

Running Workstation Setup

To install Workstation Setup, you must access the program using the shared location or UNC path for the server where Sage 100 is installed.

To run Workstation Setup

  1. Log onto the workstation using the Administrator account.

    We strongly recommend using the Administrator account rather an account with administrator rights.

  2. Close down other programs. Do not close antivirus, antispyware, and script-blocking software unless it is actually interfering with the installation.

  3. Connect to the server using the UNC path to the share point where Sage 100 Advanced is installed.

  4. Use Windows Explorer to attach to the server share point where Sage 100 is installed, and locate the MAS90\Wksetup folder.

  5. Double-click Autorun.exe to run the program; it takes a few seconds to launch.

  6. Follow the steps in the Workstation Setup wizard.

If you receive a message stating that no installation of Adobe Acrobat Reader was detected, click OK to continue with the installation. To install Acrobat Reader, start the Sage 100 installation program, and select your product from the Autorun screen. Click Productivity Applications, and then click Install Acrobat Reader.

Important! If a message appears asking you to restart the computer, you must do so before the installation will be fully functional.

If you are running through Remote Desktop Services or Citrix, you are prompted to indicate whether Sage 100 Premium will be accessed through the Terminal Server.

  • Click Yes to copy the activation key file. This allows multiple Remote Desktop Services/Citrix sessions to access Sage 100 Advanced at the same time.

  • Click No to leave the activation set for a single user.

If you typed NO ACCESS at the Server field in the Sage 100 Premium Server Path page, this message does not appear.

If you click Yes to copy the activation key file but receive a message indicating the copy was not successful, you must manually copy the file to the MAS90/Home/Lib/Keys folder.

To create a Workstation Setup DVD, copy the contents of the MAS90\WKSETUP folder to the root folder of a blank DVD. For detailed information on creating a DVD, refer to your DVD burner software.

Multiple Installations

A Sage 100 Premium workstation can attach to multiple servers. For example, if your site has three servers and Sage 100 Premium is installed on each server, you can connect to the appropriate server by clicking a single icon rather than having a separate icon for each installation.

Only one current version on a server is supported.

Adding a Server to Existing Workstation

To add a server to an existing workstation, launch the Install Sage 100 Premium Workstation program from the Sage 100 Premium server installation folder and double-click Autorun.exe to run the program. On the Program Maintenance page, click Add and enter the server name, path, and port ID associated with the server you want to add. After Workstation Setup is complete, click Finish.

Selecting a Server

If the Workstation Setup wizard has been run for only one server, your system is configured automatically for that server. Running the Workstation Setup wizard again (from a different server path) allows you to select from multiple servers using the same workstation files.

If multiple servers are found in your local configuration file, a dialog box opens and lists both the server name and the socket number on which the program is running. Select the server and socket number pair to attach to and then click OK. If you do not want to start Sage 100, click Cancel to close the program.

You cannot have multiple installations for the same version of the Sage 100 Premium server component on the same server.

Editing, Adding, and Removing Servers

Use the Select Server window to edit, add, or remove entries in the window by clicking the appropriate button.

Click Add to open a window in which you can enter a server name, alias, and socket number. After all the information is entered, click Accept to save the entry.

The Edit feature functions similarly to the Add feature, except that the window contains all of the current information about the server and port ID. The Edit Server window can be used to modify existing data or change the socket number, if necessary. To remove the server entry from the configuration file, click Remove in the Select Server window.

Aliasing a Server

It may be practical to assign an alias to the server and socket number pairs. For example, you can label one installation as “Accounting” and a second installation as “Payroll.” You can assign an alias to any server and socket number pair in the list of installed servers by clicking Alias in the Select Server window.

Select the server and socket number pair to alias by selecting the line and clicking Alias. Type the name of the alias to use for this server and socket number, and click Accept. If you do not want to alias this server, click Cancel.

The aliases associated with servers are local to each individual workstation. The configuration information is stored in the SOTA.INI file located in the \MAS90\Launcher folder. To use the same configuration files on multiple workstations, copy the SOTA.INI file to each workstation's \MAS90\Launcher folder.

Setting a Default Server

When multiple servers are present, you may want to set a default server and port ID to start up. Even if the server and port are set to Default, the Select Server window always appears; however, the selected server is the one chosen as the default. To start Sage 100 on the default server, click OK.

To set a server and socket number as the default, select the server and socket number pair by clicking the line, and selecting the Default check box. When Sage 100 is started from this workstation, the server and socket number selected as the defaults are highlighted.

Sage 100 Payroll

If you plan to use the Sage 100 Payroll module, it must be installed separately. The Sage 100 Payroll Installation and Upgrade Guide is available on the Sage 100 Documents page.

Sage Intelligence Reporting

Sage Intelligence Reporting is automatically installed when running Workstation Setup if you select the Recommended setup type.

If you select the Custom setup type and clear the Sage Intelligence Reporting option, you can install the program at a later time by rerunning Workstation Setup.

Installing Sage Intelligence Reporting

To install Sage Intelligence Reporting

  1. Make sure that Microsoft Excel is installed and activated, and then close Excel.

  2. Start the Workstation Setup wizard.

    For details, see Running Workstation Setup.

  3. Proceed through the wizard to the Setup Type screen.

  4. Select the Custom option and then click Next.

  5. Select the Sage Intelligence Reporting option and proceed through the rest of the wizard.

After the installation is complete, follow the steps under Setting Up Sage Intelligence Reporting.

Setting Up Sage Intelligence Reporting

Before using Sage Intelligence Reporting, follow the steps below to set up a repository and register the product.

The repository will be used to store Sage Intelligence Reporting data, reporting trees, report templates and other settings. Centralizing this information in one folder has the following advantages:

  • Using a single folder makes it easier to back up and restore the information.

  • Multiple users can access the information.

To set up Sage Intelligence Reporting

  1. Create a shared folder to serve as the repository. The folder can be created locally or on a network; however, you must use a UNC format when entering the repository path: \\server\share name\repository folder name

    If you are upgrading from a previous version of Sage 100, you must create a new repository. If you have custom reports that you want to use in version 2021, export them from your preexisting repository and import them into the new one.

    For more information, see the Upgrading Sage Intelligence Reporting section in the Sage 100 Customer Upgrade Guide.

  2. Grant Sage Intelligence Reporting users read and write permissions to the folder.

  3. Open the Report Manager from within Sage 100. Select Sage Intelligence Reporting > Reports > Report Manager.

  4. When the window appears asking for the path to the repository, enter the UNC path to the shared folder that you created, and click OK.

  5. When a window appears asking you to run the license manager, click Yes.

  6. In the License Manager window, enter your Sage customer account number and serial number, and then click Apply.

  7. Click Perform Registration.

Click the Help button on any Sage Intelligence Reporting window for detailed information about the product’s features.

For instructions on running Sage Intelligence Reporting outside of Sage 100, see Running Sage Intelligence Reporting outside of Sage 100.