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


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


SQL Server Connection String