Using Microsoft SQL Server as a database server for the Men and Mic=
e Suite

We recommend that the network latency=
between the SQL server and M&M Central is no more than 5 ms. Otherwise=
, the performance of M&M in conjunction with SQL Server can't be guaran=
teed to be acceptable

=20

=20

=20

Setting up the Database

Men & Mice requires that a blank =
database is created on the database server, with the collation SQL=
_Latin1_General_CP1_CS_AS, and a login (Windows or SQL server aut=
henticated) that has db_owner access to that database and an effective defa=
ult schema of mmCentral.

The attached&nbs=
p;CreateDatabase.sql=
is a sugg=
estion for the database and database server setup. Please note that t=
his script also configures the SQL server itself, which is unnecessary and =
undesirable in most cases. Therefore, review the script with your datab=
ase administrator and only run appropriate parts of it.

=20

=20
Icon=20

=20

We recommend that the SQL Server database is managed and maintained by a=
database administrator (DBA)

=20

=20

=20

Before you run the script please go t=
hrough the script and change the necessary entries accordingly. This includ=
es path strings (default C:/Data) and very important also the password, whi=
ch is set by default to "1234" in the script!

Please note that the script is=
preconfigured for an 8 core processor machine, i.e. as a best practice we =
recommend to create for each processor core one temp file. If you have only=
a two core machine please comment out the last 6 temp file creation comman=
ds in the script.

=20

=20
Icon=20

=20

The script will drop an existing database with the name "mmsuite&qu=
ot;, so take care when running the script.

=20

=20

=20

Subsequent it will create an e=
mpty database with the name "mmsuite" and the following collation=

COLLATE SQL_Latin1_General_CP1_CS_AS

It will also create a user mmSuiteDBU=
ser with the password that you have inserted in the script. <=
span style=3D"color: rgb(0,0,0);">For details please have a look into the C=
reateDatabase.sql script.

Configuring the connection parameters

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. Oth=
erwise the connection information for SQL Server will not be appended to th=
e preferences file.

Copy the mmdbprefs.exe into the data=
directory of the M&M Central.Usually:c:\=
Program Files\Men and Mice\Central\Data or c:\Program=
Files(x86)\Men and Mice\Central\Dataor on Windows Server 2008 R2 and laterc:\ProgramData\Men and Mice\Central

Then start the mmdbprefs.exe tool by=
double-click. It will ask you a few questions

=20

Choose database provider to use:
1. SQLite
2. MSSQL

=20

For MS SQL Server please enter "=
2" and confirm with Enter.

=20

Enter database server:
>

=20

Please type in the database server in=
the following format:

=20

<ip/dns name of SQL server><,port>\<Instance n=
ame>@<Database name>

=20

For example

=20

192.168.2.12\INSTANCENAME@databasename
or
192.168.2.12,1433@databasename

=20

Confirm your input by pressing the En=
ter key.

=20

Enter database user name:
>

=20

Type in the username, default in the script is "mmSuiteDBUser", t=
hat will be used to connect to your database instance on the specified SQL =
server. Then press Enter. If you let the database user name empty Windows A=
uthentication will be used instead of a user based connection (this require=
s to run the M&M Central service under credentials that have acces=
s by Windows Authentication to the database).

=20

Enter database password:
>

=20

Finally you need to provide the passw=
ord (it will not be displayed in the shell) and then press Enter.Now the preferences.cfg file=
in the data directory contains beside the fingerprint of Central (i.e. the=
"password" XML-tag) four additional XML tags: database, database=
server, databaseusername and databasepassword

Establishing a connection to Men=
& Mice Central

Restarting the Men & Mice Central service with the new preferences file=
should connect the M&M Central to your freshly created database. The M=
en and Mice Central creates the database schema (tables...) during the=
first connection.
=20
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.

Mirrored SQL Server instances

Men & Mice Central (v6.3.0.6 and above) can be made aware of mirrore=
d instances of the database. In case a failover occurs, M&M Central wil=
l try to talk to the new principal server, i.e. the failover partner, if sp=
ecified.

1. Change the databaseservername attribute in the pref=
erences.cfg or rerun mmdbprefs.exe and provide the value: &nbsp=
; "serverA@mmsuite;Failover_Partner=3DserverB"