SQL Server

Creating a Data Source for SQL Server in TrustLogix

Prerequisite Steps

1. Download Required Files:

   • Click on the Download button to obtain the zip file containing the necessary SQL scripts.

2. Execute SQL Scripts:

   • Use SQL Server Management Studio (SSMS) to execute the following SQL scripts from the downloaded zip file:

     • tlx_sqlserver_grants.sql

     • tlx_sqlserver_grants_for_aws_rds.sql

   • Ensure the scripts are run on the appropriate SQL Server instance.

3. Capture Configuration Details:

   • Note down the following details:

     • Username and password used in the SQL grants scripts.

     • Hostname and port of the SQL Server.

4. Understand TrustLogix User Grants:

   • The TrustLogix user will be granted the following permissions:

     • CONNECT, ALTER, ALTER ANY MASK, ALTER ANY SECURITY POLICY on all existing databases for masking and row access policies.

     • SELECT, ALTER, EXECUTE, CREATE FUNCTION, CREATE TABLE on TLX_POLICY_DB for masking and row access policies.

   • The TrustLogix user will also be added as a member of the db_securityadmin role for each database.

Connection Configuration

1. Server Name and Port:

   • Enter the hostname of the SQL Server instance in the format ServerName,1433 (replace 1433 with the actual port if different).

   • Refer to the guide: How to obtain the server name?

2. Username:

   • Provide the username captured from the grants script execution.

3. Password:

   • Enter the password corresponding to the username.

Final Step

• After populating all the fields, click Save to complete the registration of the SQL Server data source.