SQL Server Integration
Microsoft SQL Server 2017+
Automatically discover and classify PII fields in your Microsoft SQL Server database. Our AI scans table schemas and sample data to identify personal information like emails, phone numbers, Aadhaar numbers, and more — helping you build your DPDP data map.
Prerequisites
Network Access
- SQL Server must be accessible from the internet, or whitelist our IPs
- Port 1433 (or your custom port) must be open
- TLS encryption enabled (recommended)
Database User
Create a read-only user with minimal privileges:
-- Create a login for Privacy Labs CREATE LOGIN privacylabs_scanner WITH PASSWORD = 'your_secure_password'; -- Create user in your database USE your_database; CREATE USER privacylabs_scanner FOR LOGIN privacylabs_scanner; -- Grant read-only access ALTER ROLE db_datareader ADD MEMBER privacylabs_scanner;
Minimum Privileges Required
Required
- db_datareader role
- VIEW DEFINITION (optional)
Not Required
- db_datawriter role
- db_owner or sysadmin
Step-by-Step Setup
Navigate to Integrations
In your admin dashboard, go to Data Discovery → Integrations and click Add Connection.
Select SQL Server
Choose SQL Server from the list of supported databases.
Enter Connection Details
Fill in your database credentials:
Test & Save
Click Test Connection to verify, then Save.
Run Discovery Scan
Go to Data Discovery → Run Discovery and start the scan.
What We Scan vs. What We Don't
What We Scan
- Table names, column names, data types
- Sample data (up to 100 rows per table)
- Foreign key relationships
What We Never Touch
- No bulk data export
- No data modification
- Sample data never persisted
Azure SQL Database: Fully supported. Use your Azure SQL connection string and ensure the firewall allows our IP addresses.
Security
Encrypted Credentials
AES-256 encryption at rest.
TLS Connections
All connections encrypted in transit.
Ready to Scan Your SQL Server Database?
Connect in under 5 minutes and discover PII fields automatically.
Book a Demo