When running the grant permissions script while creating an Azure SQL agent, the script fails with the error in red
Msg 4015, Level 15, State 1, Line 16
Reference to database and/or server name in 'master.dbo.sysxlogins' is not supported in this version of SQL Server.
Azure version is 12.0
Please refer to the latest Foglight for Databases deployment guide for the required permissions for Azure SQL database agents.
RESOLUTION 1
Use the popup in the installer wizard and enter in a sysadmin account to run grant the permissions in the background
RESOLUTION 2
Ensure that a correct sysadmin level account is used in SQL Server Management Studio to run the grants script.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center