Microsoft SQL Server Authentication Options

With most database servers, you can specify a username and password directly in the connection string to authenticate with the database server. However, Microsoft SQL Server offers the following authentication options.

• Windows NT Integrated Security: Uses the identity of the ICONICS Databases Point Manager service to authenticate to the SQL Server. By default, the service is configured to log in as NT AUTHORITY\NETWORK SERVICE.
• SQL Security: Uses an explicit SQL Server user account. It requires a SQL Server account with the permission to log in to SQL Server and connect to the desired databases.
• Azure Active Directory (AAD) Integrated Security: Uses the Azure Active Directory to identify the ICONICS Databases Point Manager service account to authenticate to the SQL Server.
• Azure Active Directory (AAD) Security: Uses an explicit Azure Active Directory user account. It requires an Azure SQL Server account with permission to log in to Azure SQL and connect to the desired databases.