| title | Data Source Wizard Screen 2 (ODBC Driver for SQL Server) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 03/21/2018 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | 76326eeb-1144-4b9f-85db-50524c655d30 |
| author | David-Engel |
| ms.author | v-jizho2 |
Specify the method of authentication, and set up Microsoft SQL Server advanced-client entries and the login and password the ODBC driver for SQL Server will use to connect to SQL Server while configuring the data source.
Specifies that the driver request a secure (or trusted) connection to a SQL Server. When selected, SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored. The SQL Server system administrator must have associated your Windows login with a SQL Server login ID (for example, by using SQL Server Management Studio).
Optionally, you can specify a service principal name (SPN) for the server.
Specifies that the driver authenticate to SQL Server using Azure Active Directory. When selected, SQL Server uses Azure Active Directory integrated login security to establish a connection using this data source, regardless of the current login security mode at the server.
Specifies that the driver authenticate to SQL Server using a login ID and password.
Specifies that the driver authenticate to SQL Server using an Azure Active Directory login ID and password.
Specifies that the driver authenticate to SQL Server using Azure Active Directory Interactive mode by providing login ID. This will trigger the Azure Authentication prompt dialog.
Specifies the login ID the driver uses when connecting to SQL Server if With SQL Server Authentication using a login ID and password entered by the user or With Active Directory Password authentication using a login ID and password entered by the user or With Active Directory Interactive authentication using a login ID entered by the user is selected. This only applies to the connection made to determine the server default settings; it does not apply to subsequent connections made using the data source after it has been created.
Specifies the password the driver uses when connecting to SQL Server if With SQL Server Authentication using a login ID and password entered by the user or With Active Directory Password authentication using a login ID and password entered by the user is selected. This only applies to the connection made to determine the server default settings; it does not apply to subsequent connections made using the new data source.
Both the Login ID and Password boxes are disabled if With Integrated Windows authentication or With Active Directory Integrated authentication is selected.
Proceeds to the next screen of the wizard.
Returns to the previous screen of the wizard.