To Deploy an MYOB Advanced Instance

You deploy an MYOB Advanced instance by using the MYOB Advanced Configuration Wizard.

To Deploy a New MYOB Advanced Application Instance

  1. Run the MYOB Advanced Configuration Wizard. For example, select Start > MYOB Advanced > MYOB Advanced.
  2. On the Welcome page, click Deploy New Application Instance.

    Alternatively, on the Welcome page of the MYOB Advanced Configuration Wizard, click Perform Application Maintenance, and then click Create on the Application Maintenance page.

  3. On the Database Server Connection page, specify the database server that will be used by the MYOB Advanced instance:
    1. In the Server Type box, choose the server type. The following options are available: Microsoft SQL Server or MySQL Server.
    2. Select a server to connect to. Do one of the following:
      • In the Server Name box, type the name or the address of the server machine.
        Note: For a MySQL server, the port number defaults to 3306. You can specify the custom port number after a comma.
      • If you are using a Microsoft SQL server, select the server in the Available Servers list.

        If the server list does not include the server you are looking for, you should click Reload the List to rescan your network. The list of database servers may not have a particular server even after your network is rescanned (if, for instance, the server blocks broadcasts). If the problem persists, contact your network administrator for assistance.

        Note: If you use Microsoft SQL Server Express, the (local) option will not work even if the database server is running on the same machine. To use the server, start the SQL Browser service first, and then update the list of servers and select your server. Note that Microsoft SQL Server Express should not be used in a production environment because of its limitations.
    3. Select the authentication method to be used to connect to the database server. If you select the SQL Server Authentication option, specify an account with sufficient rights for creating the databases or making changes to them. Keep the following points in mind as you select an authentication method:
      • The selected authentication method must be supported by the database server. By default, Microsoft SQL Server 2005 is installed with Windows authentication disabled.
      • Windows authentication works only for a local Microsoft SQL Server or when both application and database servers are members of the same Windows domain.
      • Windows authentication doesn't work for a MySQL Server.
  4. Click Next.
  5. On the Database Configuration page, select the appropriate option as follows:
    • To create a new database, click Create a New Database and then type the name in the New Database's Name box.
    • To connect to an existing database, do the following:
      1. Click Connect to an Existing Database.
      2. In the Available Databases on the Server list, select a database name.
        Tip: You can search for a database, by using the Database Filter box.
      3. Depending on the schema of the database you have selected, select the relevant check box to update, repair, or set up the database, if required.
      4. If you want to shrink data after the database maintenance, select the Shrink data check box.
  6. Click Next.
  7. On the Tenant Setup page, do the following:
    1. Configure the new tenant (named Tenant) that the MYOB Advanced Configuration Wizard created by default:
      • To rename the tenant, double-click the tenant name in the Tenant Name column, type a new tenant name, and press Enter.
      • If you want to fill the database with demo data, select SalesDemo in the Insert Data column.
    2. Optional: Add more tenants if you want to create a multitenant MYOB Advanced instance. For more information about tenant setup, see To Add a New Tenant by Using MYOB Advanced Configuration Wizard.
    3. Optional: For a multitenant MYOB Advanced instance, if you want to restrict the list of tenants a user can see only to the tenants the user has access to, select the Secure Tenant on Login Form check box. In this case, the Tenant box does not appear on the Sign-In page by default and all users first authenticate themselves by entering their login and password.
    4. Optional: For a multitenant MYOB Advanced instance, if you want to configure data sharing between tenants, select the Advanced Settings check box. For more information, see Managing Tenants Locally.
  8. Click Next.
  9. On the Database Connection page, specify the authentication method that this instance of MYOB Advanced will use to connect to the database, which is one of the following options:
    • Windows Authentication: The MYOB Advanced Configuration Wizard will use the default anonymous user account used by Internet Information Services (IIS).
      Note: Windows authentication doesn't work for a MySQL Server.
    • SQL Server Authentication: Select Create Login Credentials to create a new SQL login, or select Use Existing Login Credentials and specify an existing login. The login must have at least the following rights:
      • For a Microsoft SQL server, read, write, execute, and ddl_admin
      • For a MySQL server, create, alter, drop, select, delete, insert, update, create temporary tables, and execute
  10. Click Next.
  11. On the Instance Configuration page, specify the following options:
    1. Instance Name: Type a name for this MYOB Advanced instance.
    2. Create Acumatica ERP Site: Select this option button.
    3. Local Path to the Instance: Enter the path on the local computer to this application instance.
  12. Click Next.
  13. On the Website Configuration page, do the following:
    1. In the Website Settings section, configure the list of websites and create a virtual directory. To use the URL of the IIS default site (that is, http://www.domain.com), clear the Create Virtual Directory check box.
    2. Leave the Do Not Install RabbitMQ check box cleared, which is the recommended option. The MYOB Advanced Configuration Wizard will install RabbitMQ (if it is not installed yet) to support functionality of push notifications.
      Tip: If you select the Do Not Install RabbitMQ check box, MYOB Advanced Configuration Wizard configures the MYOB Advanced instance to use Microsoft Message Queuing (MSMQ) to support functionality of push notifications.
    3. In the Application Pool Settings section, specify the application pool. You may want to use a dedicated application pool to better isolate instances and fine-tune resources that are allocated for the instance by IIS. To specify the dedicated application pool, select one of the following options:
      • To create a new application pool, click Create New Application Pool and type the name in the Application Pool Name box.
      • To use an existing application pool, click Use Existing Application Pool and select the name of the application pool in the list of available application pools.

        The list of application pools includes all the application pools you can use to install MYOB Advanced from the list of pools configured in Web Server (IIS), either classic or integrated.

        Note: MYOB Advanced employs the application pools that use one of the supported .NET Framework versions. For the list of supported .NET Framework versions, see System Requirements for MYOB Advanced 2022 R2.
  14. Click Next.
  15. On the Confirmation of Configuration page, do the following:
    1. Check the configuration settings you have specified.
    2. Optional. To make any changes, click Back to return to the required wizard page, and then make necessary changes.
    3. If you want to save the configuration settings in an XML file on your computer, click Save Configuration.
    4. Click Finish to deploy this MYOB Advanced instance.