Search the ManageEngine site:  
 

Help Center

Quick Start

File Auditing

File Analysis

Data Risk Assessment

Endpoint DLP

Cloud Protection

General settings

Release notes

Troubleshooting

Guides

Third-party software Contact us

Microsoft SQL server configuration

Configuring Microsoft SQL servers

For seamless synchronization of the Risk analysis module and MSSQL server, administrators must implement the prerequisites stated in the SQL server configuration prerequisites page.

To configure Microsoft SQL server for data discovery scans, follow these steps:

  • Select Risk Analysis from the application drop-down.
  • Go to Configuration > Data Sources > MSSQL Server.
  • Click +Add MSSQL server.
  • Enter Server Name.
  • Enter Instance Name and Port Number.
  • Choose the Authentication Type from the drop-down.
    Note: When chosen, both SQL server authentication and Windows authentication will use the credentials of the user whose details are requested below.
  • Provide the username and password based on the authentication type.

    Tip for choosing authentication type:

    • When choosing Windows authentication, use a user account with domain admin credentials to ensure the product has sufficient permission to collect logs. If you do not want to provide domain admin credentials, follow the steps in the permissions and privileges guide to set up a service account with the least privileges required.
    • When choosing SQL Server Authentication, use a user account configured within the target SQL server instance and has a minimum level permission, in this case, Read. For more details on the steps to set up a user account with the least privileges required, refer to the permissions and privileges guide.
  • Under Select Database for Scanning, choose one of the following options:
    • All Databases: Scans and monitors every database available on the SQL Server.
    • Specific Databases: Allows you to select and monitor only the databases you configure.
  • Click Save.

Note: Once the Microsoft SQL server is configured successfully, data discovery scans will be scheduled automatically by DataSecurity Plus.

DataSecurity Plus will also list the configured databases within the SQL Server instance. This information will include database size.

Viewing and editing configured servers

To manage existing data source configurations, follow these steps:

  • Select Risk Analysis from the modules drop-down.
  • Go to Configuration > Data Sources > SQL Server. On the Configured SQL Servers page, you will see a table listing the configured SQL Servers along with details regarding the status of the last data discovery scan and its scan history.
  • Click the Edit Configuration icon in the A ctions column next to the SQL Server instance.
  • Click Fetch Databases to view and add databases within this SQL Server instance. To remove a database, select one from the table below and click the delete icon.
  • Click Update once you have made the required changes.

Running data discovery scans

Once the SQL Server is configured successfully, data discovery scans will be scheduled automatically by DataSecurity Plus.

Note:

Customers who installed DataSecurity Plus prior to build 6050 can only manually schedule data discovery scans. Find the steps to schedule a data discovery scan, from here.

All DataSecurity Plus builds from 6050 will automatically schedule scans and the users can track it's progress regularly.

The time taken to complete a scan depends on the resources allocated for the data discovery scan and the volume of data to be scanned.

Check the status of the data discovery scan for any configured MSSQL server by following these steps:

  • Select Risk Analysis from the application drop-down.
  • Go to Configuration > Data Sources > SQL Server.
  • Click View History under the Execution History column of the server whose scan history you want to analyze.
  • The complete scan history for that server, including scan start time, end time, and current status, will be displayed.

You can manually initiate a scan for any SQL Server instance by clicking the rescan icon on the MSSQL Server Configuration page.

Topics in this page:

Don't see what you're looking for?

  • Visit our community

    Post your questions in the forum.

     

  • Request additional resources

    Send us your requirements.

     

© 2026 Zoho Corporation Pvt. Ltd. All rights reserved.