OS authentication is currently available on Windows operating systems. OS authentication is not available in Insights desktop for macOS.
Database connections to Microsoft SQL Server databases have two possible authentication methods: SQL Server authentication and Windows authentication. SQL Server authentication uses a SQL Server user name and password to authenticate. Windows authentication uses a local Windows user account or trusted domain account.
SQL Server relies on Windows to authenticate the Windows user accounts.
The following prerequisites are required before OS authentication can be used to create a database connection:
- Your Insights deployment must be updated to Insights 2020.2 or later. For Insights in ArcGIS Enterprise, the upgrade must include the additional steps to allow OS authentication for database connections if you are updating from Insights 2020.1 or earlier.
- The domain user must be granted delegation by the domain administrator. See the Insights connector guide for more information.
- ArcGIS Enterprise must be configured to use Integrated Windows Authentication (required for Insights in ArcGIS Enterprise only).
Use the following resources to learn more about OS authentication: