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. Once imported, new SQL Server instances are registered directly in the repository with default settings. If the SQL Server instance already exists in the repository, then SQL Secure updates the login credentials for the server.
After importing your SQL Server instances, be sure to go the the Server Group Tags view to add the new servers to tag for better management. For more information about tags, see 3.0 - Manage server group tags.
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.
OR
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.
The Import SQL Servers window opens. - Locate the file you want to import. Note that the file must be in the .csv format with content in the following format:
- column(1) servername
- column(2) login
- column(3) password
- Click Open, and then OK.
- SQL Secure validates the file format and displays the message, "Any registered servers found in the import file will have their credentials updated based on those specified in the file."
- Click OK.