# 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**     | <p>Optional command to execute immediately after successful login. The initialization command runs before each machine step that uses the specified connector configuration.<br>Note: The user executing the Flow Connect app is available in the initialization command through <code>@FlowUser\_\_email</code> (and <code>@username</code> for backward compatibility). For automations, where no user is driving the execution, both variables are set to an empty string.</p>                                                                                                                   |
| **Cleanup Command**            | <p>An optional command to execute on the database after the operation has been completed.<br>Note: The user executing the Flow Connect app is available in the cleanup command through <code>@FlowUser\_\_email</code> (and <code>@username</code> for backward compatibility). For automations, where no user is driving the execution, both variables are set to an empty string.</p>                                                                                                                                                                                                             |
| **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)                                                                                                                                                                                                                                                                                                                                                                                                                                                             |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.novacura.com/flow-connect/working-with-connect/connect-to-systems/connectors/microsoft-sql-server.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.