➤ To configure the server settings, the following fields are required.
- Instance Name
- Description
- Server IP
- Port
- Connection Type SSL/Non SSL
- Root/CA Certificate
- TLS Protocol
- Username and Password
➤ Before adding the username and password on the configuration screen, it is important to set full read-only permissions to a user. To configure SQL server in Seqrite Data Privacy application, set read only permission to a user. The db_datareader option provides full read-only access.
Here are the steps to set the db_datareader property in SQL Server Management Studio.
- Open SQL Server Management Studio and connect to the database instance where the database is located.
- Expand the Security folder in the Object Explorer pane.
- Right-click the user or role that you want to grant the db_datareader permission to and select Properties.
- In the Database Role Membership section of the Properties window, select the box next to db_datareader.
- Click OK to save the changes.
➤ If the server is hosted in a private data center, it is necessary to allow connectivity to Seqrite Data Privacy, provided that the Seqrite Data Privacy Discovery Realm is deployed on Seqrite cloud.