Page History
The Repository Status window allows you to view status of the SQL Server instances that are registered with IDERA SQL Secure, SQL Secure licenses, and the SQL Server Agent used for collecting data.
...
The SQL Server Agent Status section displays the current status of the SQL Server Agent that SQL Secure uses to collect security information.
If the SQL Server Agent is stopped , you must start the agent on the SQL Server instance hosting the Repository or snapshots cannot be taken. For more information, see Microsoft Books Online.
...
| Property | Column Description |
|---|---|
| SQL Server | Displays the name of the SQL Server instance that is being audited |
| Status | Displays any warnings or errors that may have occurred with the last snapshot |
| Last Successful Collection | Displays the date and time that the latest snapshot was taken and completed successfully |
| Last Collection | Displays the date and time that the last snapshot was attempted (whether or not it was completed successfully) |
| Collector Job Status | Describes the current status of the SQL Server job running the audit data collection |
...
| Excerpt |
|---|
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > > |