When running the auto discovery agent there is an option to grant the needed database privileges manually. Using the provided script as it is it throws an error: Wrong syntax.
This line is not correct:
Select @LoginName = ?;
As the database user is not known when the script is created you need to modify the script and add the user name manually.
Change:
Select @LoginName = ?;
To:
Select @LoginName = N'<username>';
Example: Select @LoginName = N'foglight';
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center