Table of Contents

SQL Server

Connect to Microsoft SQL Server (on-premises, Azure SQL Database, or Fabric SQL Database).

Connection Properties

Property Description
Server Server hostname or IP. Use server\instance for named instances, or server,port for non-default ports.
Database The database name.
Username SQL login username (not needed for Windows Auth or Entra ID).
Password SQL login password.

Authentication Methods

  • SQL Authentication: Username and password. Works on all platforms.
  • Windows Authentication: Uses your Windows credentials. Windows only.
  • Entra ID (MFA): Signs in with your Microsoft account via a browser popup. Works on all platforms.

Tips

  • For Azure SQL Database, use the full server name: yourserver.database.windows.net.
  • Enable encryption for cloud-hosted databases.
  • Named instances require the SQL Server Browser service to be running on the target machine.