Database guides
SQL Server
This guide connects Sheeta AI to a Microsoft SQL Server database. In the app, SQL Server appears as MSSQL.
Connect to the database
Step 1: Open connection management
In the Database sidebar, click Manage database connections, then click Add.
Step 2: Choose MSSQL
Select MSSQL as the database type. Under Add Connection By, choose Values or URL.
With Values, fill in:
- Connection Name: a name you will recognise.
- Host: the server address, such as
localhost. - Port:
1433by default. - Database, Username and Password.
With URL, paste a URL in the form mssql://username:password@host:port/database or sqlserver://username:password@host:port/database and click Parse to fill in the values.
Step 3: Test and save
Click Test Connection. When the test succeeds, click Save. Sheeta AI tests the connection again when you save and does not save a connection that fails.
Encryption
Sheeta AI turns on encryption automatically for known cloud hosts, such as Azure. For other hosts the connection is not encrypted. The server certificate is always trusted, so self-signed certificates work.
SQL Server in Docker
If SQL Server runs in a Docker container that does not publish its port, turn on Docker container tunnel and enter the container name in place of the host. See DB Connections for how the tunnel works.
Troubleshooting
- Database is not reachable: check that the server is running and that the host and port are correct. SQL Server must accept TCP connections on that port.
- Login failed: check the username and password, and that SQL Server authentication is enabled on the server.
More help is on the Troubleshooting page.