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: 1433 by 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.