Microsoft SQL Server
Connect Microsoft SQL Server to Inconvo.
What you’ll need
Section titled “What you’ll need”- Allow 52.17.120.25 to reach your SQL Server listener (default
1433). - A SQL login with
SELECTon the database/schemas you want exposed. - Permission to read metadata (e.g.,
VIEW DEFINITION) so we can enumerate tables/columns.
Fill the form
Section titled “Fill the form”- 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=falseAfter you save
Section titled “After you save”- 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
SELECTgrants.