FMS SQL Server Repository Requirements when the database is created manually (4289507)

What are the requirements if the FMS (Foglight Management Server) repository in SQL Server database is created manually?

If the DBA creates the database manually without using the sqlsvr_create_db.sql script, we have these requirements:

• SQL Server Authentication depending 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 database role on the foglight database.
• The foglight database needs to be the primary db for the foglight database account.
• If using a SQL cluster, we need the SQL Host name (actual server name), the SQL instance name, and the database name.
• The database login user name cannot be longer than 16 characters.
• (recommended/optional) in order to reduce the size of the transaction logs, set the database to “Simple Recovery” mode.