# Microsoft SQL Server

Use the SQL server connector to connect to your Microsoft SQL database. This connector supports SQL Server Database versions Microsoft SQL Server 2012 and later.

## Managing Connector : Add, Edit, or Delete

Follow the [steps in the link](https://docs.novacura.com/flow-connect/working-with-connect/connect-to-systems/managing-connector) as a guideline for connector actions: Add, Edit, and Delete.

## Configuration values

| Configuration                  | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| ------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Agent Group**                | Agent group where the connector should be executed                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| **Server**                     | Address to the Microsoft SQL Server                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| **Initial Catalog**            | The name of the database to be used. If there are multiple databases on the server that you have permission to use, you have to specify the Initial Catalog.                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| U**sername**                   | User to login to the database with                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| **Password**                   | Password for User                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| **Connection Pooling**         | Sets whether connection pooling should be used                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| **Connection Timeout**         | The timeout, in seconds, for establishing a connection to the SQL Server.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| **Trust Server Certificate**   | Allows the connector to accept self-signed SQL server certificates without validating it against a certificate authority (CA)                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| **Override Connection String** | <p>If a connection string is specified here, it will be used instead of the one generated from the settings above. You can use the connection string to specify additional connection properties. </p><p>For example, the following connection string ensures that when connecting to the SQL Server, the connector will trust the server's SSL/TLS certificate without validating it against a certificate authority (CA):<br></p><p><em>Server=\<SQL\_SERVER\_ADDRESS>;Database=\<DATABASE\_NAME>;User Id=\<USERNAME>;Password=\<PASSWORD>;<strong>TrustServerCertificate=True</strong>;</em></p> |
| **Schema/AppOwner**            | Database schema name. The default schema is dbo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| **Initialization Command**     | Optional command to execute immediately after successful login                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| **Cleanup Command**            | An optional command to execute on the database after the operation has been completed.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| **Command Timeout**            | Command timeout, in seconds, to use when executing a script or a query. If not set, the default value will be used (usually 90 seconds)                                                                                                                                                                                                                                                                                                                                                                                                                                                             |