Documentation

gitHub

Connect to a SQL Server instance

The SQL Server engine can hosted on-premises, on virtualized machines in a private or public cloud, or as a managed instance with the Azure SQL Database service.  

 

Several authentication methods are available.

 

In the Hackolade connection settings dialog, give a meaningful name to the connection, choose the source (on-prem/cloud or Azure SQL Database), then set the database name, the host and port:

 

SQL Server Connection settings

 

 

Important: the host IP address and the port must correspond exactly to the values in the SQL Server instance.  You may want to check using the SQL Server Configuration Manager (SQL Server Network Configuration -> Protocols for <instance name> -> TCP/IP -> [right click] properties)

Image

 

 

If you reference a named instance in the host field, please make sure to leave blank the port.

 

Or you may choose to provide a connection string which includes: host, port, username and password:

 

SQL Server Connection String