WORKAROUND
*** Using SQL Server RDS as a FMS repository has not been certified and supported by Quest R&D ***
In the installer, when pointing to an RDS instance, and entering the “master/sysadmin” user into the bottom fields, the installer throws the following error:
Clicking ‘OK’ brings you back to the configuration screen. At that time, the user has been created successfully, although the database has not. The likely cause of this, is that the configuration process tries to run the following script, which fails on an RDS instance:
EXEC sp_changedbowner 'foglight_pirep';
1). Change from the option to automatically create the database to manual.
2), Run the provided scripts scripts\sql-templates folder to manually create the Foglight repository. The scripts should run successfully (except for the sp_changedbowner shown above),
3) Manually assign dbowner rights to the created database
The remainder of the installer completed without error, and the initial startup process succeeded (although it ran a bit longer than normal).
STATUS
Enhancement Request FOGGENERAL-I-98 has been logged to certify and support SQL Server RDS as a Foglight repository. This enhancement will be reviewed by Quest Product Management for consideration in a future release of the Foglight Management Server.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center