Please note that the following needs to be run from the data directory, i.e. the same directory that contains the preferences file for Central. Otherwise the connection information for SQL Server will not be appended to the preferences file.
- Download the Men&Mice mmdbprefs.exe tool
- Copy the mmdbprefs.exe into the data directory of the Men&Mice Central.
Usually located in one of these locations:
- C:\Program Files\Men and Mice\Central\Data
- C:\Program Files(x86)\Men and Mice\Central\Data
- C:\ProgramData\Men and Mice\Central (Windows Server 2008 R2 and later)
- Then start the mmdbprefs.exe tool by double-click. It will ask you a few questions
An example preferences.cfg file for the Windows Authentication method should look like (databaseusername tag must be present and the value attribute must be set to empty string):
<password value="the fingerprint hash"/> <database value="MSSQL"/> <databaseserver value="<name or ip of the SQL server>\<name of instance, e.g. SQLEXPRESS>@,<name of database, e.g. mmsuite"/> <databaseusername value=""/>
Men&Mice Central running on Linux
Please note that a ODBC driver will need to be installed on the Linux machine to be able to use Microsoft SQL Server
- Navigate to the data directory of the Men&Mice Central:
Usually located in:
Edit the preferences.cfg file with in that directory with the following:
Please note that the DatabasePassword value if prefixed by "plaintext:" will be swapped out by the Men&Mice Central for a password hash during start up.
<Database value="MSSQL" /> <DatabaseServer value="ip/dns name of SQL server><,port>\<Instance name>@<Database name>" /> <DatabaseUsername value="mmSuiteDBUser" /> <DatabasePassword value="plaintext:<your password here>" />
Save your changes.
Establishing a connection to Men&Mice Central
Since the database was freshly created you can now follow the normal installation procedure. Please see the installation guide and the user manual of the M&M Suite for further information.
SQL Server in High Availability
Mirrored SQL Server instances
Please note that this feature is in maintenance mode by Microsoft and may be removed in a future version of Microsoft SQL Server.
Please note that Database Mirroring is only supported for Men&Mice Central running on Windows.
Men&Mice Central (v18.104.22.168 and above) can be made aware of mirrored instances of the database. In the case a failover occurs the Men&Mice Central will try to talk to the new principal server, i.e. the failover partner, if specified.
Change the DatabaseServer value in the preferences.cfg or rerun mmdbprefs.exe and provide the value:"serverA@mmsuite;Failover_Partner=serverB", where "serverA" and "serverB" are the principal and mirror SQL servers, and "mmsuite" is the name of the database
- If the machine running M&M Central does not have SQL Server installed, install the Microsoft SQL Server Native Client tools.
Always On Availability Groups
Please note that Always On Availability Groups is only supported for Men&Mice Central running on Linux.
Men&Mice Central supports the use of Always On Availability Groups (v9.3.0 and above), In the case of a failover occurs the Men&Mice Central will refresh its database connections to the new primary replica.
Change the DatabaseServer value in the preferences.cfg to the virtual IP address or the FQDN of the availability group listener:
<DatabaseServer value="virtual ip/fqdn of availability group listener><,port>\<Instance name>@<Database name>" />