How do I collect from Microsoft SQL server
Supported versions of Microsoft SQL Servers are 2012, 2014 and 2016 through the Nanitor Collector.
- You need to have a Nanitor Collector up and running. A single collector can collect from multiple network devices, servers and databases.
- 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.
- You need to have a user to connect to the database (we recommend an Active Directory user).
Adding the device to Nanitor
Run this command to avoid putting the passwords in .bash_history:
Now we add the credentials (the passwords are stored locally in an encrypted format).
The credentials are created as follows (In this example DOMAIN\user is an Active Directory user and is allowed to access the test database). Note that we need to escape the backslash because we are in a shell:
sudo /usr/lib/nanitor-collector/bin/nanitor-collector-ctl credential_add --title default-sqlserver --access_method database --username DOMAIN\\user --password MyPassword
Now we add the database itself:
sudo /usr/lib/nanitor-collector/bin/nanitor-collector-ctl database_add --title sqlserver-01 --database_type sqlserver --address 172.16.154.3 --credential_title default-sqlserver
This can take a few seconds as it will complete authenticating and fully collecting the first results. Once completed, the results will be immediately available in the Nanitor UI. The collector will continue collecting results once every 24 hours.
If the results do not appear in the Nanitor UI, ensure that the benchmarks are selected and in scope for the organization (Administration - Organization Management - Settings - Benchmarks tab).