> For the complete documentation index, see [llms.txt](https://docs.novacura.com/flow-connect/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.novacura.com/flow-connect/working-with-connect/connect-to-systems/connectors/microsoft-sql-server.md). # 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** |

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.

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):

Server=\;Database=\;User Id=\;Password=\;TrustServerCertificate=True;

| | **Schema/AppOwner** | Database schema name. The default schema is dbo | | **Initialization Command** |

Optional command to execute immediately after successful login. The initialization command runs before each machine step that uses the specified connector configuration.
Note: The user executing the Flow Connect app is available in the initialization command through @FlowUser\_\_email (and @username for backward compatibility). For automations, where no user is driving the execution, both variables are set to an empty string.

| | **Cleanup Command** |

An optional command to execute on the database after the operation has been completed.
Note: The user executing the Flow Connect app is available in the cleanup command through @FlowUser\_\_email (and @username for backward compatibility). For automations, where no user is driving the execution, both variables are set to an empty string.

| | **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 This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## 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, and the optional `goal` query parameter: ``` GET https://docs.novacura.com/flow-connect/working-with-connect/connect-to-systems/connectors/microsoft-sql-server.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. 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.