Search

Middle Tier Installation

See Middle Tier.

On this page:

Before Setup

These items must be checked before beginning Middle Tier set up.

Installation

All of the following parts must be completed in order. Perform the installation directly on the Middle Tier server. Log in as an administrative user.

Part 1: Set Up the Server Config File

  1. Download this file (right-click, Save As): OpenDentalServerConfig.xml, and place it in the application directory of Open Dental on the Middle Tier server. Edit the file to set the users and passwords. 

    <?xml version =1.0"?> 
<ConnectionSettings>
        <DatabaseConnection>
            <ComputerName>localhost</ComputerName>
            <Database>opendental</Database>
            <User>root</User>
            <Password>Password</Password>
            <UserLow>root</UserLow>
            <PasswordLow>Password</Password>
            <DatabaseType>MySql</DatabaseType>
        </DatabaseConnection>
</ConnectionSettings>

    • If MySQL users/passwords are not set up, use root for the User and leave the password blank.
    • The password should be plain text and entered in both Password and PasswordLow sections.
    • To enable running reports through Middle Tier, also enter MySQL user credentials in the UserLow and PasswordLow sections. See MySQL Security for instructions on creating a MySQL read-only user account for this purpose. If a read only user account is not needed, the root user can be used.

Part 2: Enable Internet Information Services (IIS)

The steps below vary depending on the Windows edition.

Windows Server Users

  1. Navigate to the Manage menu and select Add Roles and Features.
  2. Select Role-based or feature-based installation.
  3. Within Server Selection, ensure the information selected is accurate and valid. If yes, then click Next.
  4. Ensure that all aspects of IIS, ASP.net, and DotNet are selected within the Server (IIS) selection.
    • Server (IIS)
      • Common HTTP Features
        • Default Document
        • Directory Browsing
        • HTTP Errors
        • Static Content
      • Security
        • Request Filtering
        • IIS Client Certificate Mapping Authentication
        • Windows Authentication
      • Application Development
        • .Net Extensibility 3.5
        • .Net Extensibility 4.8
        • ASP.NET 4.8
        • ISAPI Extensions
        • ISAPI Filters
    • Management Tools
      • IIS Management Console
      • IIS 6 Management Compatibility
        • IIS Metabase Compatibility
      • IIS Management Scripts and Tools
      • Management Service
  5. Verify that .Net 3.5 and 4.8 features are selected.
    • NET Framework 3.5 Features
      • Net Framework 3.5 (includes .NET 2.0 and 3.0)
      • HTTP Activation
      • Non-HTTP Activation
    • .NET Framework 4.8 Features
      • .NET Framework 4.8
      • ASP.NET 4.8
      • WCF Services (all)
  6. Confirm the selections and click Install.

Windows 11 Users

  1. Open Windows Features by pressing Win + R to open Run and type 'optionalfeatures', click Enter.
  2. In Windows Features, ensure the following features are enabled:
    • .NET Framework 4.8 Advanced Services
      • ASP.NET 4.8
      • WCF Services (all)
    • Internet Information Services
      • Web Management Tools
        • IIS Management Console
      • World Wide Web Services
        • Application Development Services
          • .NET Extensibility 3.5
          • .NET Extensibility 4.8
          • Application Initialization
          • ASP.NET 4.8
          • ISAPI Extensions
          • ISAPI Filters
      • Common HTTP Features
        • Default Document
        • Static Content
      • Security
        • IIS Client Certificate Mapping Authentication
        • Request Filtering
        • Windows Authentication
  3. Click OK and allow Windows to install the additional features.

Part 3: Set Up Server Website in IIS

  1. Open Internet Information Services (IIS) Manager by searching the Start menu or Win + R and enter 'InetMgr.exe', click Enter.
    • On Windows Server, open Server Manager and click IIS. Do not use IIS 6.0.
  2. Expand Connections and click Application Pools.
  3. Right-click DefaultAppPool, Advanced Settings.
  4. Ensure the .NET CLR Version is 4.0 and Enable 32-Bit Applications is True.
  5. Click OK.
  6. In Connections, right-click Default Website, Add Application.
    • The Alias determines how the connection is referred to in the URI. This can be anything, but the physical path needs to point to the Open Dental application folder.
  7. Click OK.

Part 4: Configure Server Settings in IIS

  1. In IIS, click on OpenDentalServer, then double click .NET Globalization.
  2. Set the Culture and UI Culture languages to match the region.
  3. Set Enable Client Based Culture to True and click Apply.
  4. Select the OpenDentalServer site in the object browser. Double-click on the Configuration Editor.
  5. Use the Section dropdown at the top of the Configuration Editor to select the system.web/httpRuntime section.
  6. Modify the maxRequestLength attribute and click Apply on the right.
    • The maxRequestLength value is in kilobytes while the maxAllowedContentLength is in bytes.
  7. Use the Section dropdown at the top of the Configuration Editor to select the system.webServer/security/requestFiltering section.
  8. Expand the requestLimits attribute, modify the maxAllowedContentLength value, and click Apply on the right.
  9. After making these edits it may be necessary to restart the site by selecting the the site name (e.g., Default Web Site) in the object browser on the left and selecting Restart under the Manage Website section on the right.

Part 5: Connect Workstations

When connecting from a client workstation, the Choose Database window looks similar to the image below. Test this on the server first, then on workstations.

The above connections settings will be used from other workstations, but not from the Middle Tier server. After the initial testing, the upper direct connection settings will be used anytime on the server. This is required in order to perform version updates.

Part 6: Set Up Workstation Config Files

Step 12: When running Open Dental as Administrator and connecting via Middle Tier, there should be a FreeDentalConfig file in the application folder similar to the text below. This file should replace the existing .xml file on all the workstations. 

<?xml version =1.0"?>
<ConnectionSettings>
        <ServerConnection>
		<URI>http://10.10.1.191/OpenDentalServer/ServiceMain.asmx</URI>
		<User>tanya</User>
		<UsingAutoLogin>True</UsingAutoLogin>
		<UsingEcw>False</UsingEcw>
	</ServerConnection>
<DatabaseType>MySql</DatabaseType>
</ConnectionSettings>

Additional Setup Options

Single Sign-on

Set up single sign-on to allow users to automatically log into Open Dental.

To enable:

  1. Launch Open Dental.
  2. In the Choose Database window, enter the Open Dental user name and password.
  3. Check Log me in automatically.
  4. Click OK to save.

The FreeDentalConfig file will store the state of the Log me in automatically check box and the credentials will be stored within the Credential Manager. See Technical Details below for more information.

To disable (requires the Choose Database, Permissions):

  1. Launch Open Dental.
  2. In the Main Menu select File, Choose Database to open the Choose Database window.
  3. Uncheck Log me in automatically.
  4. Click OK to save.

The FreeDentalConfig file will store the state of the Log me in automatically check box and the user will be prompted to enter their user name and password the next time Open Dental is launched.

If the user does not have security permissions, disable single sign-on in the FreeDentalConfig file:

  1. Navigate to the Open Dental directory, typically C:\Program Files (x86)\Open Dental.
  2. Right-click the FreeDentalConfig file and select Edit or Open With and select Notepad.
  3. Look for <UsingAutoLogin>True</UsingAutoLogin> and replace True with False.
  4. Save the file.

The next time the user launches Open Dental, they will be prompted to enter their user name and password.

Technical Details

When using the single sign-on feature via Middle Tier Open Dental makes use of the Credential Manager that comes natively to all Windows 8 and higher versions. The Credential Manager was designed by Microsoft for 3rd party app developers on the Windows Store. This created a uniform and secure place for Microsoft app developers to store user credentials and passwords. The information entered in to the Credential Manager requires a user sign in to access and takes care of all encryption. As such the user should not remove the Credential Manager entry that Open Dental has made or else the feature will no longer work.

The Windows user currently logged in must have read and write permissions to the FreeDentalConfig file in order to enable single sign-on. Do not right-click on the Open Dental shortcut on the Desktop and run as administrator if the Windows user currently logged in does not have elevated privileges. Windows will prompt for administrator credentials when the user does not have sufficient privileges. Entering another user's credentials will cause the Open Dental credentials entered into the Choose Database window to be stored under the other user's Credential Manager and single sign-on may not work as expected.

Updating Middle Tier

Install and perform updates directly from the database server. When an update is performed, run the Setup file on the Middle Tier server from the OpenDentImages folder after the update is performed on the database server. Any attempt to perform an update from another computer will cause errors. These items must be checked before beginning setting up Middle Tier.

Additional Resources