If a Microsoft Dynamics NAV Server instance is configured for multitenancy, then you can use the Microsoft Dynamics NAV Server Administration tool to mount and dismount tenant databases.

Note
You can also mount and dismount tenants by using the Mount-NAVTenant and Dismount-NAVTenant cmdlets.

To mount or dismount a tenant

  1. Open the Microsoft Dynamics NAV Server Administration tool.

    • Choose Start, and in the Search programs and files box, type Microsoft Dynamics NAV Administration, and then choose the related link.

  2. Verify that the Microsoft Dynamics NAV Server that you want to mount the tenant on is running, and if not, then start it:

    1. In the left pane of Microsoft Dynamics NAV Server Administration tool, choose a Microsoft Dynamics NAV Server computer. Unless you are administering a remote computer, this is Microsoft Dynamics NAV (local).

    2. In the center pane, if the Status of the Microsoft Dynamics NAV Server instance is Stopped, then right-click it, and then choose Start.

  3. In the left pane, expand item for the Microsoft Dynamics NAV Server instance on which you want to mount the tenant, and then choose the Tenants item.

  4. To mount a tenant, in the Actions pane, choose Mount Tenant, fill in the parameters on the Mount Tenant dialog box, and then choose the OK button.

    The following table describes the parameters on the Mount Tenant dialog box.

    Setting Description Required

    ID

    Specifies the ID of the tenant to mount. If the tenant database has not been mounted on a Microsoft Dynamics NAV Server instance before, then you can specify any ID that you want that is not being used. This ID is then assigned to the database. If the tenant database has been mounted in a Microsoft Dynamics NAV Server instance before, then you must specify the tenant ID that is assigned to that database or specify another ID and select the Overwrite Tenant ID in the Database check box.

    Yes

    Database Name

    Specifies the name of the Microsoft Dynamics NAV database that you want to mount on the Microsoft Dynamics NAV Server instance. For example, to mount the CRONUS International Ltd. demonstration database, specify Demo Database NAV (7-1).

    Yes

    Database Server

    Specifies the network name of the computer that is running SQL Server and the SQL Server database instance to connect to. You specify the value by using the format ComputerName\SQLServerInstance. The default database instance for Microsoft Dynamics NAV is NAVDEMO.

    No

    Alternate Tenant IDs

    Specifies the alternative IDs for the tenant, such as host names for the Microsoft Dynamics NAV Web client, SOAP web services, OData web services, or the Microsoft Dynamics NAV Windows client.

    If you use alternative IDs for tenant resolution in the Microsoft Dynamics NAV Web client, you must also enable some of the UrlRewrite rules in the web.config file for the Microsoft Dynamics NAV Web Server components.

    No

    Allow Application Database Writes

    Specifies whether the tenant can write to the application database.

    No

    Enable NAS Services

    Specifies whether NAV Application Server services are enabled for the tenant. For more information about NAS, see Configuring NAS Services.

    No

    Default Company

    Specifies the default Microsoft Dynamics NAV company for the tenant. A tenant can contain several companies. This is the company that opens by default in Microsoft Dynamics NAV client.

    No

    Default Time Zone

    Specifies the default time zone in which web service and NAS services calls on the tenant are run. You can specify the following values:Values:

    • UTC - All business logic for web services and NAS services on the server instance runs in Coordinated Universal Time (UTC). This is how all web services business logic was handled in Microsoft Dynamics NAV 2009 and Microsoft Dynamics NAV 2009 SP1.
    • Server Time Zone - Services use the time zone of the computer that is running Microsoft Dynamics NAV Server.
    • <ID of any time zone recognized by the current version of Windows> - Specifies any Windows time zone as defined in the system registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. For example, Romance Standard Time.

    No

    Overwrite Tenant ID in Database

    Specifies whether to overwrite the tenant ID in the database if the database has been mounted as a tenant earlier. Select this check box if you want to use the tenant ID that is specified in the ID parameter instead of the tenant ID in the database that you are mounting to the nav_server instance.If you clear this check box, and the tenant database has previously been mounted with a different tenant ID, an error will occur.

    No

    Synchronization Mode

    Specifies how the database schema for the tenant database is synchronized with the database schema that the mounted application database defines. The default value is Sync. You can select one of the following values.

    • ForceSync - The database schema in the tenant database is updated with the application database schema even if data is lost. For example, if a table or a field has been deleted in the current application, the table or field is removed from the tenant database even if it contains data.
    • DisallowChanges - If the database schema in the tenant database differs from the current application, the tenant cannot be mounted against the Microsoft Dynamics NAV Server instance.
    • Sync - The database schema in the tenant database will be updated unless data is lost. For example, if a table or a field has been deleted in the current application, and it contains data in the tenant database, the tenant cannot be mounted against the Microsoft Dynamics NAV Server instance.
    • CheckOnly - Microsoft Dynamics NAV Server tests if a change in the current application will cause data loss in the tenant database if the tenant is mounted with Synchronization Mode set to ForceSync. For example, if a table or a field has been deleted in the current application. and it contains data in the tenant database.

    No

  5. To dismount a tenant, in the center pane, right-click the tenant, and then choose Dismount Tenant.

See Also