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.
FMS SQL Server Repository Requirements when the database is created manually
Description
What are the requirements if the SQL Database is created manually?
Resolution
If the DBA creates the database manually without using the create_db script, we have these requirements:
SQL authentication depneding upon which version of FMS is running(Windows authentication is not supported in older version but the latest version of FMS supports it).
SQL_Latin1_General_CP1_CS_AS collation is required (we need this case-sensitive collation).
The foglight database user needs db owner permissions on the foglight database.
The foglight db needs to be the primary db for the foglight db account.
If using a SQL cluster, we need the SQL Host name (actual server name), the SQL instance name, and the database name.
The db account used cannot be over 16 characters in length.
(recommended/optional) in order to reduce the size of the transaction logs, set the database to “Simple Recovery” mode.
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.