Windows Authentication provides a more secure way for an Application to access an MS SQL database without storing the database password in the Genesys configuration.
Full details about how to enable Windows Authentication with MS SQL Server are described in the "Microsoft SQL Server Databases" section of the Framework Database Connectivity Guide.
This topic describes how to enable and configure Framework Applications to use Windows Authentication with MS SQL Server.
Before you can configure individual applications to use Windows Authentication, you must first create Windows processes on the MS SQL Server for each component that will be accessing the database. Specifically, you need to create a Windows process for the following components in the scenarios that applies to your configuration:
Follow the instructions here to configure the Windows processes required.
How you configure a Framework Application to use Windows Authentication depends on how it accesses its database, that is, whether it uses DB Server or not. These scenarios are described below.
If Configuration Server is using DB Server, you must:
Using a DSN named "sqldsn", the entries would look something like this:
...
[confserv]
...
dbthread=false
...
[dbserver]
host=<name of host on which DB Server is running>
port =<host port through which to communicate with DB Server>
dbengine=mssql
dbserver=dsn
dbname=sqldsn
username=<this field can be filled with a dummy username>
password=<this field can be left empty or filled with a dummy password>
...If Configuration Server is not using DB Server, you must set dbthread=true and the options that describe the Configuration Database in the configuration file confserv.cfg, as shown in the example below.
Using a DSN named "sqldsn", the entries would look something like this:
...
[confserv]
...
dbthread=true
...
[dbserver]
host=<name of host on which DBMS is running>
port =<host port through which to communicate with the DBMS>
dbengine=mssql
dbserver=dsn
dbname=sqldsn
username=<this field can be filled with a dummy username>
password=<this field can be left empty or filled with a dummy password>
...If Message Server is using DB Server, you must set dbthread=false in the [messages] section of the Message Server Application object. Configure a DAP in which DB Server is set. DB Server must be using DB Client 8.5.1 or higher. You must also configure a Windows process for DB Server, as described here.
If Message Server is accessing the Log Database directly (without DB Server), you must still configure a DAP but it will not point to DB Server. Set dbthread=true in the [messages] section of the Message Server Application object. You must also set up a Windows process for Message Server, as described here.
In both cases, set the Username field to a dummy username.