Configuring the Microsoft SQL Server Database Connection

You can configure the native SQL Server database name to connect to a Microsoft SQL Server database and retrieve the database details.

You must provide the native SQL Server database name to configure the connection information for the Microsoft SQL Server database.

To configure the Microsoft SQL Server connection

1. In the Data Adapter Type box, select Microsoft SQL Server Database.

2. In the Data Source Configuration section, do the following:

   

   1. In the Data Source time zone list, click the time zone of the database that the external data source system is referencing.

      The default time zone is the time zone of your computer. You can select the (UTC) Coordinated Universal Time option if the external data source system being referenced uses UTC for its time fields.

      You can click the Automatically adjust time for Daylight Savings check box if the time zone that you select is affected by daylight saving time (DST). For more information about time zone handling, see Time Zone for a Data Source.

   2. In the Server name box, type the name of the server where the SQL Server database is installed and configured.

   3. In the Database name box, type the database name that you want to connect.

   4. Select the authentication mode.

      • By default, the authentication mode shows the default Windows Authentication option and the user name and password boxes are not available.

      • Select the SQL Server authentication option if you want to connect using the SQL server credentials. You must specify the user name and password for SQL Server authentication.

      • Select the Azure Active Directory authentication option if you want to connect using the Azure Active Directory credentials. You must specify the user name and password for the Azure Active Directory authentication.

3. Click Connect. If the connection succeeds, the Getting schema notification message appears. It can take few minutes to retrieve the schema from the data source. For more information about retrieving the schema, see Retrieve the schema.

4. Click Done and then click Save.