Details
When the Liongard inspector is activated from the auto-discovery process it will default to use the same user account that the Liongard Agent is running as. The SQL inspector will only land successfully if the SQL instance is setup to allow Windows Authentication and if the Liongard Agent user is permitted. If this fails, follow the steps below.
Steps to Remediate
Edit the Inspector and set the Authentication Type drop-down to “SQL”
In the Username and Password fields, provide the credentials for a sysadmin user.