Cisco Cisco Enterprise Chat and Email 11.5(1) Guide De Montage
16
Enterprise Chat and Email Installation Guide
Verifying Collation Settings
Collation settings are typically chosen while installing SQL Server 2014. Since collations specify the rules
for how strings of character data are sorted and compared, based on particular languages, a particular type of
collation is required for the application to process and present information accurately.
for how strings of character data are sorted and compared, based on particular languages, a particular type of
collation is required for the application to process and present information accurately.
On the Collation settings screen, choose SQL Collations and select the following option: Dictionary order,
case-insensitive, for use with 1252 Character Set. For example, SQL_Latin1_General_CP1_C1_AS.
Although this is the recommended collation, it is not mandatory. Any ASCII, case insensitive collation can
be used. If you have already installed SQL Server 2014, consult your DBA and verify that the collation
setting chosen is ASCII (case insensitive). The application databases will be installed using the collation that
is configured for MSSQL Server.
case-insensitive, for use with 1252 Character Set. For example, SQL_Latin1_General_CP1_C1_AS.
Although this is the recommended collation, it is not mandatory. Any ASCII, case insensitive collation can
be used. If you have already installed SQL Server 2014, consult your DBA and verify that the collation
setting chosen is ASCII (case insensitive). The application databases will be installed using the collation that
is configured for MSSQL Server.
Choosing Authentication Method for Database Connectivity
The application supports two methods of authentication for connecting to the database.
SQL Server authentication
Windows authentication
As part of the installation process, you will be asked to select the authentication method. Your selection will
depend on the security policies of your organization, and should be consistent with the authentication
method configured in SQL Server.
depend on the security policies of your organization, and should be consistent with the authentication
method configured in SQL Server.
If you choose Windows authentication, certain additional steps must be completed before you begin installing the
application. These steps are outlined in the
application. These steps are outlined in the
. Also refer
to
Creating SQL User for Installing ECE Databases
Skip this section if you want to use the default
SA
user to install the ECE databases.
Create a user for installing the ECE databases and make sure the following roles are assigned to the user:
dbcreator, securityadmin, sysadmin
Running SQL Server Services
Make sure the following SQL services are running. These services should be started using the same domain
account that you have created for installing the ECE application. If your MSQL Services are running with a
different domain account, then use that account. You can also use a local account with administrative
privileges.(
account that you have created for installing the ECE application. If your MSQL Services are running with a
different domain account, then use that account. You can also use a local account with administrative
privileges.(
SQL Server Service
SQL Full-text Filter Daemon Launcher Service: This service is required for text searches.
SQL Server Agent Service: This service is used by the Reports module.
SQL Server Integration Service: This service is used by the Reports module.