Workloads SQL Server is designed to collect configuration data and performance metrics from the nominated SQL Server Instance. In order to run a successful collection for SQL Server for Workloads, the specific conditions detailed below must be met.
The SQL Server version and edition must be supported. Please see knowledge base article Product Matrix SQL Server for more information.
In order to upload a Collection to the Live Optics Web Portal, the Collector must have an external internet connection and our services must be capable of passing through the Firewall.
For the user to be authorized against a SQL Database, the user must have VIEW SERVER STATE permission on the Instance. Please contact your SQL DBA to request these permissions.
If your SQL Server Instance sits on a remote server, your Windows Authentication credentials must be permitted to authenticate against. You will not have the ability to authenticate with a different Windows user for SQL Server collection.