​

Before you connect

• CONNECT on the database
• SELECT on the target schema(s) and tables

​

Connection fields

Port note — The standard on-premises SQL Server port is 1433. Azure SQL Database and many managed SQL Server instances use 1433 as well. Supaboard’s default shows 3342 — update it to 1433 for Azure SQL or most RDS/Cloud SQL instances.

​

SSH Tunnel fields

​

Finding your connection details

​

Azure SQL

1. Open your SQL server in the Azure Portal.
2. On the Overview page, copy Server name — this is your Host (format: servername.database.windows.net).
3. The default Port is 1433.
4. Under Security → Networking, add a firewall rule for each Supaboard egress IP.
5. Ensure Allow Azure services and resources to access this server is set if needed.

​

Amazon RDS for SQL Server

1. Open the RDS Console and select your instance.
2. Under Connectivity & security, copy the Endpoint — this is your Host.
3. The default Port is 1433.
4. Add Supaboard egress IPs to the instance’s VPC security group (inbound TCP on port 1433).

​

Google Cloud SQL for SQL Server

1. Open the Cloud SQL Console and select your instance.
2. Under Connect to this instance, copy the Public IP address — this is your Host.
3. Default Port is 1433.
4. Under Connections → Authorized networks, add each Supaboard egress IP.

​

SSL

• SSL Certificate — paste the server’s CA certificate in PEM format if your instance uses a self-signed or private CA. For Azure SQL and AWS RDS, the certificates are publicly trusted and no upload is needed.

​

SSH Tunnel

• Instance is not publicly accessible
• On-premises SQL Server behind a corporate firewall
• Security policy requires all external traffic to pass through a bastion host

• The bastion server can reach the SQL Server host on port 1433
• Supaboard’s egress IPs are allowed on the bastion server’s SSH port (default 22)
• The SSH user has permission to forward connections
• If using a private key, it is in PEM format

​

Recommended database user permissions

-- Create a SQL Server login
CREATE LOGIN supaboard WITH PASSWORD = 'Strong_Password_Here!';

-- Create a database user mapped to the login
USE your_database;
CREATE USER supaboard FOR LOGIN supaboard;

-- Grant read-only access to the default schema
GRANT SELECT ON SCHEMA::dbo TO supaboard;

-- Grant connect and select on the database
GRANT CONNECT TO supaboard;

GRANT SELECT ON dbo.your_table TO supaboard;

​

Troubleshooting