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.