Blog

Software tips, techniques, and news.

Configuring Azure SSO For FileMaker

Step 1: Open FileMaker Admin Console

  1. Open a new browser window and navigate to your FileMaker Server Admin Console.

  2. From the top nav bar, click Administration.

  3. On the left, click External Authentication.

filemaker server external authentication.
  1. Select Change next to Microsoft.

  2. The fields revealed are what you will populate in the following steps. For now, take note of the redirect URI at the top: https://YourDomain/oauth/redirect.

    1. Replace “YourDomain” with the domain of the FileMaker Server. This is also the domain of the admin console. So, for the domain cloud.example.com, the redirect URI would be https://cloud.example.com/oauth/redirect. 

Step 2: Create a New Registration

  1. Sign in to the Azure portal you want to use to manage SSO.

  2. Click Microsoft Entra ID.

filemaker azure microsoft entra ID.
  1. From the left menu, click App registrations.

  2. Create a New registration.

microsoft app new registration.
  1. Enter a descriptive Name.

  2. Back in Register an application in Azure, select Accounts in this organizational directory only (Default Directory only – Single tenant) under Supported account types.

  3. Choose Web under Redirect URI and copy in the redirect URI from the Admin Console.

  4. Click Register.

Step 3: Modify Authentication Settings

  1. On the left, click Authentication.

microsoft authentication settings.
  1. Deselect Access tokens.

  2. Select ID tokens.

  3. Make sure under Supported account types that Accounts in this organizational directory only (Default Directory only – Single tenant) is selected.

supported account types default directory only.
  1. Set Allow public client flows to No.

Step 4: Populate Admin Cloud Azure Fields

  1. On the left, click Overview.

microsoft azure overview.
  1. Copy Application (client) ID to the field Azure Application ID in the Admin Console.

  2. Copy Directory (tenant) ID to the field Azure Directory ID in the Admin Console.

azure directory ID.
  1. On the left, click Certificates & Secrets.

  2. Under Client secrets, click New client secret.

  3. Enter a Description and select an expiration date. Keep in mind if you do not set Expires to Never, you will have to update this field.

microsoft azure certificates and secrets settings.
  1. From this new secret, copy Value to the field Azure Key in the Admin Console.

    1. This will be the only time you can copy this value. If you don't save this value now, you will have to create another secret later.

  2. Click Save Authentication Settings

  3. Below this section, in Database Sign In, set Microsoft to Enabled.

microsoft azure database sign in.

Step 5: Set API Permissions

  1. Back in Azure, click on API permissions on the left.

  2. Click Add a permission.

Click Add a permission.
  1. Click Microsoft Graph.

request api permissions microsoft graph.
  1. Click Delegated permissions.

microsoft graph delegated permissions.
  1. Search for user.read and select the User.Read permission and click Add permissions.

    1. Since user.read may already be populated, you can discard if Add permission remains greyed out.

  2. Click Grant admin consent for.

microsoft azure grant admin consent.

Step 6: Create New Group

  1. Click Microsoft Azure, then click Groups.

azure services groups.
  1. Click New group.

microsoft azure groups new group.
  1. Click No owners selected and choose the owners of the group.

microsoft azure new group settings.
  1. Click No members selected and add the users who you want to use SSO.

  2. For Group type, choose Security.

  3. For Group name, give a descriptive name.

    1. Since a group will correspond to a permission set, it is suggested to name this group according to the permissions its members will have.

  4. For Group description, enter a description.

  5. For Azure roles can be assigned to the group, select No.

  6. For Membership type, select Assigned.

  7. Click Create.

Step 7: Add Group to FileMaker App

  1. Click on the newly created group.

  2. Copy the Object Id.

group object id.
  1. Open the FileMaker application you want to use SSO with.

  2. In the upper menu bar, click File, then Manage, then Security.

  3. Click Authenticate via and choose Microsoft Azure AD.

authentication via microsoft azure ad.
  1. In the bottom left, click New.

  2. On the right, select Group.

  3. For Group Name, paste the Object Id.

  4. Make sure Active is true.

  5. For Privilege Set, select the desired privilege set.

  6. For Description, write a short description.

  7. Click OK.

If you want to assign different privilege sets to different users, you will need to repeat steps 6 and 7. Each created group corresponds to a single FileMaker privilege set.