Skip to main content
All CollectionsData sources
Troubleshooting SQL Server with Glide
Troubleshooting SQL Server with Glide

Address common questions with SQL Server and Glide.

Updated over a week ago

Accessing SQL Server in Glide

SQL Server as a data source is available to Business and Enterprise customers only.

SQL and Updates Consumption

SQL data sources consume updates only when you actively modify data within your Glide app (add, edit, or delete operations). Routine syncing and querying operations do not use up your Glide app's allotted updates. Changes that result in adding, editing, or deleting data from either Glide or the connected SQL database will accrue updates.

Read more about Updates.

Supported Versions of SQL Server

Glide currently does not distinguish between different versions of SQL Server. For the best performance and compatibility, it’s recommended to use the latest version of SQL Server.

Locating Configuration Credentials

When setting up SQL Server with Glide, you will need the correct configuration credentials, which include the username, password, host, and database name. These are typically found within your hosting platform’s database access settings or provided as a connection string.

Configuring IP Allowlist for SQL Server

If your SQL Server host platform requires an IP address to be added to the allowlist for security reasons, you should add Glide’s IP address:

SQL Server Security

Most hosted platforms use certificates that have been signed by trusted root certificate authorities. Glide's platform supports such certificates in addition to certificates issued by AWS RDS service.

Users of Google CloudSQL should utilise the CloudSQL specific integration as it will make use of Google Cloud Platform APIs in order to connect using secure ephemeral certificates.

If you are self-hosting your database and don't have the ability to acquire a root signed certificate (or your host doesn't provide one) you will need to disable TLS certificate verification at this time.

Adding Multiple SQL Server Databases

You can integrate multiple SQL Server databases in one Glide app. Here’s how to add additional databases:

  1. Open your Glide app and go to the App Settings menu.

  2. Select “Integrations.”

  3. Select “Add” and choose SQL Server from the list.

  4. Enter the required details for your new database connection.

Did this answer your question?