MOVEit Central can use either a MySQL or a Microsoft SQL Server database.
Choose the database engine that MOVEit Central should use:
MySQL - a small-footprint database engine that MOVEit Central will install and administer. See My SQL below.
Microsoft SQL Server - a widely-used database engine. You must supply a pre-installed instance of SQL Server if you choose this option, along with the following information:
Server name - The hostname or IP address of the server. If the server is listening on a non-standard port, add a command and the port number after the hostname.
Instance (if needed) - This is typically blank.
Click Next, and then go to the appropriate database below for further instructions.
My SQL
If you choose MySQL as your database engine, you will see the following dialog where you configure the credentials to be used by MySQL:
The following user name and password credentials are required to set up MOVEit Central:
Database Administrator - The superuser account for MOVEit Central. The database administrator is always root. Click Suggest to have the install suggest a password, or enter a password in the box provided.
Database User - The standard account for MOVEit Central. Enter the database username. Click Suggest to have the install suggest a password, or enter a password in the box provided.
If you choose Microsoft SQL Server as your database engine, you will see the following dialog:
Enter the following information:
Credentials to be used during the install - Provide the credentials to access the existing instance of Microsoft SQL Server. Select an authentication type to use during installation:
Use Windows Authentication during install - The currently logged-on user will be used. There must be a corresponding user with the same password on the Windows server running SQL Server, and this user must be authorized in SQL Server.
Use SQL Server Authentication during install - Specify an existing SQL Server username and password.
Database to create - You must specify the name of the database to create. In most cases you should simply accept the suggested default.
Credentials to be used by MOVEit Central - Select an authentication type to be used by MOVEit Central:
Use Windows Authentication - The user under which the service runs will be used. There must be a corresponding user with the same password on the Windows server running SQL Server, and this user must be authorized in SQL Server.
Use SQL Server Authentication - Specify an SQL Server username and password to create.
