Skip to content

Setup Microsoft SQL Server on Privacera Portal

These steps apply to both Self-Managed and Data Plane deployments..

  1. For Self-Managed, log in to the Privacera Portal; for Data Plane, log in to the Privacera Discovery Admin Console.
  2. Navigate to Settings > Data Source Registration
  3. Under the system name you added here, click the more icon. Select Add Application > JDBC APPLICATION
  4. Under Configure JDBC Application, provide values for the Application Name and Application Code fields.

  5. Under Application Properties, provide values for the following:

    Important

    Identify the user who must have appropriate permissions in your data source. For scanning, you need a user with read permission, and for processing compliance policies, you need read and write permissions. Login credentials of that user are needed for the JDBC Username and JDBC Password properties as shown below.

    • JDBC Url: jdbc:sqlserver://<domainName>:<port>;databaseName=<db_name>

    • JDBC Username: <user_with_readwrite_permission>

    • JDBC Password: <login_credentials_of_identified_user>

    • JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

    For more information about Driver Class You can refer List of JDBC Driver Class for all datasources

    Tip

    You don't need to update any other fields during the initial setup. You can update them later as needed.

  6. Click TEST CONNECTION. Ensure that a message named success is displayed.

  7. Click SAVE

Comments