All Collections
Inspectors
Microsoft SQL Server
Microsoft SQL Server | Connectivity Succeeded But User Does Not Have sysadmin Role
Microsoft SQL Server | Connectivity Succeeded But User Does Not Have sysadmin Role
Updated over a week ago

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โ€
    โ€‹

    image.png

  • In the Username and Password fields, provide the credentials for a sysadmin user.

Did this answer your question?