SQL Server

SQL Server Connection Guide

Data Bridge Pro supports Microsoft SQL Server 2012 and later, including Azure SQL Database and Azure SQL Managed Instance.

Connection Settings

Setting	Description	Example
Server	Hostname or IP	sql-server.company.com
Port	Default: 1433	1433
Database	Database name	SalesDB

Authentication Options

Windows Authentication (Recommended)

Uses your Windows login credentials. Most secure—no password storage needed.

SQL Server Authentication

Username and password stored securely in Windows Credential Manager.

Azure Active Directory

For Azure SQL Database with AAD integration. Supports MFA.

Connection String

Server=myserver.database.windows.net;Database=mydb;User Id=user@domain.com;Password=****;Encrypt=True;

Required Permissions

• SELECT - Read data
• INSERT, UPDATE, DELETE - Write data
• VIEW DEFINITION - See table structures

Troubleshooting

• Named instances: Use format server\instance
• Firewall: Ensure port 1433 is open
• Azure SQL: Add your IP to firewall rules in Azure Portal