Microsoft SQL Server

1) Create a dedicated SQL Server login

What: A non-human account used only by Querio, with least-privilege access.

How (in SQL Server Management Studio or via T-SQL as a sysadmin or securityadmin):

-- Create the login at the server level
CREATE LOGIN querio_user WITH PASSWORD = 'STRONG_PASSWORD';

2) Create a database user mapped to the login

What: A database-scoped user tied to the login.

USE my_database;
CREATE USER querio_user FOR LOGIN querio_user;

3) Grant read-only access

What: Give Querio only the ability to read data in the target database.

-- Grant membership in the built-in read-only role
ALTER ROLE db_datareader ADD MEMBER querio_user;

4) Collect and share the connection string

What: This is the format Querio will use in the connection field.

server=<hostname_or_ip>;database=<database_name>;user=<username>;password=<password>;

How to find each value:

• server: Hostname or IP address of your SQL Server instance. Include <port> if not default (1433).
• database: The database Querio should query.
• user: querio_user (or your chosen username).
• password: The password you set.