Skip to content

Microsoft SQL Server

Connect Microsoft SQL Server to Inconvo.

  • Allow 52.17.120.25 to reach your SQL Server listener (default 1433).
  • A SQL login with SELECT on the database/schemas you want exposed.
  • Permission to read metadata (e.g., VIEW DEFINITION) so we can enumerate tables/columns.
  • Display name: Label shown inside Inconvo.
  • Host / Port: Your SQL Server endpoint and TCP port (instances still listen on a port).
  • Database: Target database name.
  • Username / Password: Dedicated login scoped to that database.
  • Advanced options → Custom options: Add encrypt=true&trustServerCertificate=false (recommended) or any other connection parameters. We append these to the connection string.

Example:

sqlserver://USER:PASSWORD@HOST:1433/?database=DBNAME&encrypt=true&trustServerCertificate=false
  • We deploy the connector and start schema sync; status shows Connecting while it completes.
  • Ensure TCP/IP is enabled and the firewall/security group includes the egress IP above.
  • For Azure SQL, make sure the server firewall or private endpoint allows that IP and the login has the necessary SELECT grants.