Skip to content

How do I collect from Microsoft SQL server?

Supported versions of Microsoft SQL Servers are 2012, 2014, and 2016 through the Nanitor Collector.

Prerequisites

  1. You need to have a Nanitor Collector up and running. A single collector can collect from multiple network devices, servers, and databases.
  2. You need to have the IP address of the Microsoft SQL database and the collector needs to have network access to connect to the database.
  3. You need to have a user account to connect to the database (we recommend an Active Directory user). This user needs to have select permissions to all the objects on the server in question, especially in the Master database and other system databases. See How do I prepare MS SQL database cluster for collection by Nanitor? for more details.

Adding the device to the collector

Adding devices and credentials to the collector is covered here Using the Nanitor collector - Nanitor Knowledge Base