Microsoft SQL Server Connector
Connect to Microsoft SQL Server for natural language queries.
Overview
The MS SQL connector supports:
- SQL Server 2016+
- Azure SQL Database
- Windows and SQL authentication
- Schema discovery
Prerequisites
- SQL Server instance
- User credentials
- Network connectivity
Authentication
SQL Authentication
Username and password for SQL Server.
Windows Authentication
Use Windows/domain credentials (requires configuration).
Configuration
| Setting | Description |
|---|---|
| Host | Server hostname |
| Port | Server port (1433) |
| Database | Database name |
| Username | SQL login |
| Password | Login password |
| Encrypt | Enable encryption |
| Trust Cert | Trust server certificate |
Setup Steps
- Add Connector: Knowledge → Add Data Source → MS SQL Server
- Enter Connection: Host, port, database
- Provide Credentials: Username and password
- Configure Encryption: If required
- Test & Create: Verify and save
Best Practices
- Use SQL authentication for simplicity
- Enable encryption for security
- Create dedicated read-only login
- Filter schemas if many exist
Troubleshooting
Connection failed: Check firewall and port
Login failed: Verify credentials and permissions
Certificate error: Configure trust settings