Skip to main content

SQL Server

Category: Direct connection

Microsoft SQL Server. Direct connection.

Connection requirements​

  • Host
  • Port
  • Database name
  • Username
  • Password

Where to find these​

These values come from your database administrator (DBA) or from the existing JDBC/ODBC connection string.

  • Host / Port — Host is the server name or IP address where SQL Server runs (for a named instance possibly server\instance); Port is the database's listening port (default 1433). Found in the server configuration or available from your DBA.
  • Database name — The name of the specific database (catalog) you want to connect to.
  • Username / Password — Preferably use a dedicated SQL service account with read-only rights (least privilege) on the relevant database, rather than a personal or admin account.

Is the database behind a firewall or on-premises? Then an Integration Runtime is needed to establish the connection — see Connecting a data source.

Official documentation: JDBC Driver for SQL Server — Connection URL

See also: Integration catalog · All data source requirements · Integrations — overview