Connect your dataSupported integrations
SQL Server
Connect Microsoft SQL Server to Querio.
1. Create a dedicated login
What: Create a SQL Server login for Querio.
CREATE LOGIN querio_user WITH PASSWORD = 'STRONG_PASSWORD';2. Create a database user
What: Map the login to the database Querio should query.
USE my_database;
CREATE USER querio_user FOR LOGIN querio_user;3. Grant read-only access
What: Give Querio read-only access to the database.
ALTER ROLE db_datareader ADD MEMBER querio_user;4. Share connection details
Provide:
- Server host
- Port, usually
1433 - Database
- Username
- Password
Connection string format:
mssql+pyodbc://<username>:<password>@<host>:1433/<database>?driver=FreeTDS&TDS_Version=8.0URL-encode any special characters in the username or password (e.g. @ becomes %40). Querio's sandbox uses the FreeTDS ODBC driver — the driver=FreeTDS query parameter is required.