Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
SQL Server 2000 users are granted sysadmin roles unlike more recent versions of SQL Server
Cause
The SQL Server grant privilege script has a check of the SQL Server instance version before granting privileges to the user.
If the instance is a SQL Server 2000 (or below), the script will grant the sysadmin privilege.
If the instance is at SQL Server 2005 or higher, the script will add only the privileges required for monitoring the SQL Server instance. These privileges are described in the Foglight for Databases deployment guide.
Resolution
Workaround Use the attached MSSQLPermissionsGrant_4375155.sql script to grant the privileges to the monitored SQL Server instance. Users may require to be logged into Supportlink to download this file.
Status Monitoring SQL Server 2000 instances is no longer supported by the Foglight SQL Server cartridge. Defect ID FOG-8384 has been logged to remove references in the grant privileges script to provide sysadmin privileges to versions 9.0 (SQL Server 2005).
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.