SQL Server connection configuration
Overview
When you connect to SQL Server directly, select Local DB as the location, select SQL Server as the data type, and configure the detailed settings.
Configuration
SQL Server Authentication
| No | Item | Description |
|---|---|---|
| 1 | User Name | Username for the SQL Server account. |
| 2 | Password | Password for the SQL Server account. |
| 3 | Authentication | Select SQL Server Authentication. |
| 4 | SQL Server Host | |
| 4 | Database | |
| 6 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
Windows Authentication
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select Windows Authentication. |
| 2 | SQL Server Host | |
| 3 | Database |
SQL Server Connection String
SDI uses System.Data.SqlClient to connect to SQL Server.
You can connect to SQL Server by using SQL Server Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | SQL Server Connection String |
| 2 | SQL Server Connection String | Enter the details of the SQL Server Connection String. * Do not enter user and password information in the Connection String. Reference:SqlConnection.ConnectionString |