Skip to content
DataSquaresDocs

SQL Server

SQL Server is generally available in the DataSquares connection wizard.

  1. In DataSquares, open Data Sources and choose Add data source.

  2. Pick SQL Server in the connector picker (search or browse by category).

  3. Fill in the connection details below, then test the connection and save.

Connection details

Section titled “Connection details”
Field What to enter
Host The hostname or IP address of your SQL Server server.
Port Prefilled with 1433 (the SQL Server default) — change it if your server listens elsewhere.
Database The database to connect to.
Username / Password Credentials for a user with read access to the tables you want to analyze.
TLS Enable if your server requires an encrypted connection.

Grant the connection user read-only access — DataSquares only ever reads from your source.

Grant read-only access

Section titled “Grant read-only access”
CREATE LOGIN datasquares WITH PASSWORD = '********';
USE analytics;
CREATE USER datasquares FOR LOGIN datasquares;
ALTER ROLE db_datareader ADD MEMBER datasquares;

Instances and ports

Section titled “Instances and ports”

The form takes a host and port — for a named instance, find its TCP port (SQL Server Configuration Manager → your instance → TCP/IP) rather than using HOST\INSTANCE syntax, and make sure TCP/IP is enabled. Default instances listen on 1433.

Common errors

Section titled “Common errors”
Error Cause / fix
Login failed for user SQL authentication must be enabled (Mixed Mode) — Windows-only auth rejects SQL logins
certificate errors on connect the server forces encryption with a self-signed cert — enable TLS in the form; for production, install a CA-signed certificate
timeout port blocked, TCP/IP disabled on the instance, or SQL Browser needed for a named instance
Section titled “Related”
© 2026 DataSquares