Microsoft SQL Server

In the Database tool window ( View | Tool Windows | Database), click the Data Source Properties icon .

On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Microsoft SQL Server.

Check if there is a Download missing driver files link at the bottom of the data source settings area. As you click this link, AppCode downloads drivers that are required to interact with a database. The IDE does not include bundled drivers in order to have a smaller size of the installation package and to keep driver versions up-to-date for each IDE version.

You can specify your drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

From the Authentication list, select the authentication technology that you want to use. The following options are available:

• User & Password: use your login and password for a database.

• Kerberos: use Kerberos for authentication.

• No auth: connect to database by using connection URL only, no authentication is required.

• Domain credentials: use Windows domain authentication for the connection.

To ensure that the connection to the data source is successful, click the Test Connection link.

(Optional) If you are connecting to a data source that contains a lot of databases and schemas, in the Schemas tab, select the schemas that you need to work with.

Click OK to create the data source.