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. The most secure option, because no password is stored.

SQL Server Authentication

If you save the connection, the username and password are encrypted with Windows DPAPI for your Windows account and stored in your user profile.

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