Note:
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 username 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:
- 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).
Resources
Use the following resources to learn more about OS authentication: