Microsoft SQL Server

Supported versions

Microsoft SQL Server 2022

Create a connection to Microsoft SQL Server

To create the connection, you need these connection details:

• Database name - You do not have to specify the database. With no database specified, you can import metadata from every database that is available for that connection.

• Hostname or IP address

• Port number or Instance name - If the server is configured for dynamic ports, use the Instance name.

• Username and password

• Domain name - If the Microsoft SQL Server has been set up in a domain that uses NTLM (New Technology LAN Manager) authentication, select Use Active Directory and enter the name of the domain that is associated with the username and password.

• SSL certificate, if required by the database server

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Restriction

Except for NTLM authentication, Windows Authentication is not supported.