Database Tab

Use this tab to configure a database.

You can point an existing installation to a new database. New content will be stored in the new database but the existing data is not converted or migrated to the new database. To correctly populate the database tables, you must run a repair.

Select one of the following database types, and customize the database settings as required.

• Use MySQL
• Use Microsoft SQL Server
• Use Microsoft Azure SQL

  MySQL Settings

• DSN. The ODBC Data Source Name of the database. There is rarely a need to change this from the default of "micstats".
• MySQL root password. The password of the "root" user in the MySQL database. This is stored encrypted in the registry, and is used only by the install program. The previous value is not displayed in the dialog box when the program starts--not even masked by *'s--for security reasons.

  Microsoft SQL Server/Azure SQL Settings

• SQL Host: The hostname of the SQL Server. For example, myserver.server.database.windows.net
  • If needed, add ",port": Add the port number if you are not using the default port.
• Instance, if any: The name of the SQL Server "instance". This is usually empty, meaning the default instance.
• Database: The name of the database. The default name is "micstats".
• Use Windows Integrated Authentication. (MSSQL only) MOVEit Automation authenticates to the SQL Server using the credentials associated with the MOVEit Automation service. These credentials are shown on the radio button; for instance, "(.\micsvc)" means the local Windows user micsvc (as opposed to a domain user). The SQL Server must have a login with the same name, associated with a Windows username of the same name.
• Use SQL Server Authentication. MOVEit Automation authenticates to the SQL Server using the specified SQL login and password. The password is stored encrypted in the local registry. These credentials must exist on the SQL Server, and there must be a corresponding user mapping in the "micstats" database on that server. These are created during the database creation and do not need to be changed.
• User: The SQL database user name.
• Password: The SQL database password.

  Test DB Connection. Click this button to test whether you can connect to the database using the specified settings.