Required database permissions

administrator

Specific database permissions are required in order to upgrade your FactoryLogix database using the Server Management tool. The administrator who performs the upgrade must have the sysadmin fixed SQL server-level role (or an equivalent permission such as the securityadmin role).

Before performing a database upgrade, add the server role sysadmin to the Windows account running FactoryLogix Server Management or the SQL user authenticating against the database. Note that this configuration also depends on the administrator having that Windows account already added and configured for SQL access/login.

Note

The procedure outlined in this topic may very slightly depending on the version of SQL Server and SQL Server Management Studio you use. For more information about SQL server-level roles, see this Microsoft article.

Start SQL Server Management Studio.
Navigate to Security > Server Roles > sysadmin.
Right-click sysadmin, then select Properties.
Select the Add button, then use the Browse button to locate the user you want to assign to the sysadmin role.
Select OK until you are returned to the SQL Server Management Studio window.