Return
-
Title
Invalid usage of the option SIZE in the CREATE/ALTER DATABASE statement when installing Foglight with SQL Server repository -
Description
When installing the Foglight Management Sever with a SQL database, the following error is encountered in the setup wizard during the database creation stage:
-
Cause
Insufficient permissions for the SQL Administrator account to create the database. -
Resolution
See the requirements for creating the FMS database here.
"A setup with an external database has the advantage of using existing infrastructure. For setup, a remote administrator user/password (with rights to create users, tables, and databases) is required. Remote administrator access must be granted."