Skip to main content

Configure NDC SQL database

Netwrix Data Classification uses Microsoft SQL Server database as metadata storage. During installation, the system prompts you to create a dedicated NDC SQL database on your SQL Server instance. Upon installation completion, you need to configure it according to the following steps for the product to function properly. You can create the database manually before the product installation—Using SQL Server Management Studio or Transact-SQL. See Create a Database for detailed instructions on how to create a new database.

NOTE: For performance purposes, Netwrix strongly recommends to separate NDC and SQL Server machine.

For certain product features, SQL Server Standard or Enterprise edition is required.

To configure NDC database

NOTE: The account used to create the NDC SQL database must be granted the dbcreator server-level role.

  1. On the computer where SQL Server instance with the NDC SQL database resides, navigate to Start → All Programs → Microsoft SQL Server → SQL Server Management Studio.

  2. Connect to the server.

  3. Locate the NDC_Database, right-click it and select Properties.

  4. Select the Files page and set the Initial Size (MB) parameter for PRIMARY file group to 512 MB.

  5. Click Expand next to PRIMARY file group and set Autogrowth / Maxsize as follows:

    OptionDescription
    File Growth- Recommended—128 MB. - Large environment— 512 MB.
    Maximum File SizeSelect Unlimited.

  6. Go to Options page and ensure that the Recovery model parameter is set to "Simple".

    NOTE: Netwrix recommends that you don't change the recovery model to avoid log files growth.