Connecting to SQL Server

Connecting to SQL Server

Authenticating a connection to Microsoft SQL Server enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Sources can pull data.

Adding

The Data Hub area of the platform is where you can add connections for connectors. Navigate the side menu to Data Hub > Connections.

On the Connections page:

  • Click the ADD CONNECTION button on the top right to bring up a list of connections.
  • Click on the SQL Server option.

Authenticating

After adding a connection, fill in the required properties and save.

Connection String

The SQL Server connection string to be used by connectors to access your database.

Windows Authentication is NOT supported; you must include username and password credentials in the string.

The SQL user specified MUST have at least db_ddladmin and db_datawriter database-level roles assigned. For simplest configuration, grant db_owner role to the user.

Verify SSL Encryption

Encrypt Connection Checks if your SQL Server has a valid certificate installed to ensure the Connector uses SSL encryption for all data sent between the Platform and your SQL Server.

Click the SAVE button on the top right to store your configuration and automatically verify the connection.

Additional Info

  • SQL connections are only available on Premium accounts, and users must be at the Administrator level to see the option.
  • The SQL user-specified MUST have at least db_ddladmin and db_datawriter database-level roles assigned.
    For the most straightforward configuration, grant the db_owner role to the user.
  • You must configure your database firewall to accept connections from our cloud servers.
    Get a list of our platform’s cloud IP addresses.

Troubleshooting Tips

To help you get your SQL connection working as quickly as possible, we’ve listed some common connection errors that you might encounter and how you can resolve them.

TLS Version Error

If your SQL connection fails with the error message:

A connection was successfully established with the server, but an error occurred during the login process. (provide: SSL Provider; error: 0 – An existing connection was forcibly closed by the remote host)

The error message suggests that your SQL server does not support TLS 1.2.

All communications between our platform and external servers require a minimum support for the TLS 1.2 security protocol.

To remedy this issue, an upgrade/update on your SQL server might be necessary to enable TLS 1.2 or higher. If this is the case, then you will need to contact your IT team to request this upgrade.

Once your server has been updated, you should see that the Connection will start working.

Check if your database server is configured for TLS 1.2 or higher communication.

    • Related Articles

    • Form Connector – SQL Server

      After adding and authenticating an SQL Server Connection, you can add Data Source Connectors to pull data from a database or push data on form submissions using Form Connectors, which is what this article is about. Our platform lets you quickly and ...

    • SQL Server Data Source Connector

      After adding and authenticating an SQL Server Connection, you can add Form Connectors to push data to a database or pull data from a database using Data Source Connectors. Our platform lets you quickly and easily connect your data sources to a SQL ...

    • Data Source Connector – SQL Server

      After adding and authenticating a SQL Server Connection, you can add Form Connectors to push data to a database or pull data from a database using Data Source Connectors, which is what this article is about. Our platform lets you quickly and easily ...

    • SQL Form Connectors – Custom SQL

      There are two ways to control the flow of data to your SQL tables using one of our SQL form connectors (SQL Server, MySQL, or PostgreSQL): “Auto Maintain” and “Custom SQL“. In this article, we’ll look at “Custom SQL” and how you can use it in your ...

    • Connecting to FTP

      Authenticating a connection to an FTP server enables communication between the two platforms. This must be successfully added before Form Connectors can push or Data Sources can pull data. Adding The Data Hub area of the platform is where you can add ...