The Register a SQL Server wizard allows you to designate the SQL Server instances that you want SQL Secure to audit. The Register a SQL Server wizard allows you to do the following:
- Select the SQL Server instance you want to audit with SQL Secure
- Specify the credentials used to connect to your SQL Server instance and collect data
- Select which objects you want SQL Secure to audit
- Schedule collection times
- Configure your email notifications
The Register a SQL Server wizard must be completed before SQL Server instances can be audited by SQL Secure. For every SQL Server instance you would like to audit, the Register a SQL Server wizard must be completed.
The Register a SQL Server Wizard will prompt you for the SQL Server location, credentials to use for auditing, filter criteria, and then schedule your audits. Once you have set up your SQL Server instance for auditing, SQL Secure will apply your settings and display this instance in the Security Summary and Explore Permissions tree panes.
These configuration settings are stored in the Repository.
Register a SQL Server using the Register a SQL Server wizard
SQL Server instances must first be added to SQL Secure before the auditing process can begin.
To add a SQL Server to SQL Secure:
- Select File > Register a SQL Server from the toolbar.
- Click Next on the Welcome to the Register SQL Server Wizard window.
- Type the name of the SQL Server instance in the Server field or click Browse to locate the SQL Server instance you would like to register.
- Select the authentication mode SQL Secure should use to connect to the selected SQL Server instance.
If you select to enter the credentials , click Next and the Enter Credentials window will open. Enter the credentials you would like to use for auditing, re-enter your password, and then click Next.
If the login configuration for the SQL Server you wish to audit is case-sensitive , you must enter your login information in a case-sensitive format on the Credentials window.
Select to either enter snapshot filters manually or to copy existing filters from another server configuration.
If you want to define the data collection filters manually , enter them on the Specify data collection filter window and click Next.
If you want to copy data collection filters from another server , select the registered server from the list and click Next.
Verify that the servers you want to register are listed on the SQL Server Registration Complete window, and then click Finish.