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:
server=<hostname_or_ip>;database=<database_name>;user=<username>;password=<password>;