Installing SQL Server

Before you install MiVoice AnalyticsMiContact Center Business, you must install SQL Server 2014/ 2016/ 2017/ 2019 Express. If you need full version of SQL to be installed onto a remote server, see the System Engineering Guide. Your SQL Server version must include Management Tools (available as a separate download for SQL Server 2016/ 2017/ 2019 Express Edition).

Before installing SQL Server, you must configure the appropriate default collation settings. See the following Mitel Knowledge Base article for details: https://mitel.custhelp.com/app/answers/answer_view/a_id/1000779/loc/en_US.

Note:

You must disable SQL Replication on the SQL Server.
Ensure you use the SQL Server edition that will support your required data storage needs. SQL Server 2014/ 2016/ 2017/ 2019 Express. If you need full version of SQL to be installed onto a remote server, see the System Engineering Guide. This can store up to 10 GB of data per database. If you require more than 10 GB of data per database, you must purchase a licensed copy of SQL Server. For data storage examples and SQL Server guidelines, see the MiContact Center Business System Engineering GuideMiContact Center Business and MiVoice Analytics System Engineering Guide.
If you will use MiVoice Analytics in conjunction with remote SQL Server, you must ensure that MSDTC is enabled on the SQL Server or YourSite Explorer will not function properly. For complete details, see https://mitel.custhelp.com/app/answers/answer_view/a_id/1001160/loc/en_US.

You can download SQL Server Express Editions free from the Microsoft website.

Note:

You must install BluStar server for Line State monitoring.

For MiVoice Connect, install BluStar on the DVS server.
For MiVoice Office 400 and MiVoice 5000, install BluStar on the MiCC Server or any remote machine.

Adding SQL Server security roles to the administrative account

In order to properly create and configure databases, the administrative account being used to install MiContact Center BusinessMiVoice Analytics must have the dbcreator role on the SQL server.

If you have installed SQL Server 2014/ 2016/ 2017/ 2019 Express (or a full version of SQL Server 2014/ 2016/ 2017/ 2019), you must also verify that the NT AUTHORITY\SYSTEM server role also has these permissions. For more information, see the following KB article: https://mitel.custhelp.com/app/answers/answer_view/a_id/1002628/loc/en_US.

Note:

If you do not want the administrative account being used to install MiContact Center BusinessMiVoice Analytics to be configured with those SQL permissions, there are two alternatives:

Add the local system account as dbcreator.
Set the following services, application pools, and local databases to run under the identity account:
- Services:
  - MiContact Center Media Router
  - MiContact Center Mass Transit Runtime
- Application Pool:
  - CCMWa
- Local databases:
  - CCMRouting
  - CCMRuntimeServices
  - Ccmwa

SQL Server best practices

If you are installing SQL Server 2014/ 2016/ 2017/ 2019 Express (or a full version of SQL Server 2014/ 2016/ 2017/ 2019), ensure you follow these best practices:

On the Server Configuration window, ensure you provide a local server administrator account name in the Account Name fields and have the service Startup Type fields set to Automatic.
On the Database Engine Configuration window, on the Account Provisioning tab, ensure you specify a local server administrator in the Specify SQL Server administrators pane. If the current user has local administrator privileges on the server, click Add Current User.

↑