SQL Server and Azure User Models - Database Reference Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external - OnBase/Database-Reference-Guide/Foundation-23.1/Database-Reference-Guide/Installation/Database-Security/The-RDBMS-Authentication-Layer/SQL-Server-and-Azure-User-Models - 2025-05-01

Database Reference Guide

Platform
OnBase
Product
Database Reference Guide
Release
Foundation 23.1
License

The model used to authenticate OnBase database user accounts depends on your environment. Specifically, your environment determines whether database user accounts are:

  • A SQL user that logs on to the SQL Server instance and is mapped to a database user

  • A database user that is authenticated at the database level using a password

The database user account type models are configured upon installation depending on your environment, as shown in the following table.

Environment

Database User Model

SQL Server

SQL user with login mapped to a database user.

SQL Server with a Partially Contained Database

Database user with password.

Azure SQL Managed Instance with a Partially Contained Database

Database user with password.

Tip:

For more information about the containment feature, see the SQL Server documentation provided by Microsoft.

Note: Uncontained Databases that are within Azure SQL Managed Instances are not supported.