IDERA SQL Secure requires that you register any SQL Server instances that you want to monitor before auditing begins. The Register a SQL Server option allows you to add instances to SQL Secure one at a time. For environments having many SQL Server instances, a quick time saver is to import a .csv file. The Import SQL Servers option lets you quickly upload a file containing the SERVERNAME, LOGIN, and PASSWORD data for the instances in your environment that you want to audit.
To import SQL server instances:
- In the Security Summary view, click Import SQL Servers at the top of the Summary tab. Alternatively, you can go to File menu and select Import SQL Servers.
- In the Manage SQL Secure view, click Import SQL Servers at the top of the Repository Status window. Alternatively, you can go to File menu and select Import SQL Servers.