Prerequisites to running a SQL Server collection in Limited Preview Mode in Workloads (02/07/20)
Limited Preview is designed to collect limited configuration data 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 the Basic Index and Product Matrix KB 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 another Windows user in the Limited Preview of SQL Server for Workloads.