1. Overview

• Definition: Covers the network configuration and character limits you need to connect Mobio’s CDP platform to Microsoft SQL Server.
• Users: System Admin, DBA (Database Administrator).

2. Terminology & Configuration Parameters

• MSSQL Server — A database management system built by Microsoft.
• Standard port — 1433.

3. Prerequisites

• Related article: Create Connector: Database
• Permissions: Open an Inbound Rule for Port 1433 in your Windows Firewall (or perimeter firewall) to allow the Mobio platform through. Your SQL Server must also have Mixed mode authentication enabled (Windows and DB user authentication combined).

4. Configuration Limits by Field

Mobio applies strict validation rules for SQL Server connections:

• Database Name — Up to 128 characters. Spaces are allowed, but the entire name must be wrapped in square brackets [ ] (e.g., [Cust Profile]). Case-sensitive.
• Hostname/IP — Up to 253 characters (IPv4 or a routable domain name). IPv6 isn’t supported. Remove any accidental leading/trailing spaces. Don’t include a protocol prefix (http/https).
• Port — Any static value from 1–65535. The standard MSSQL port is 1433. No spaces or letters allowed.
• Username — Up to 128 characters (supports a dedicated login or user account). Never use these characters: \, [, ], or ".
• Password — Spaces are allowed. Mobio doesn’t trim spaces, wherever they appear.

5. Operational Rules

• TCP Dynamic Ports: If your server uses a dynamic port that keeps changing, Mobio’s scan targets a fixed port and will time out. Set up a Static Port instead.

6. Frequently Asked Questions (FAQ)

• Q: How do I test connectivity myself before configuring it in Mobio?
  • A: Run a Telnet test: nc -zv <hostname> 1433 in your terminal.

7. Next Steps

Back to Create Connector: Database