Configuring Windows authentication through the SQL server

To configure a Windows authentication log-in user when SQL server and CIS are installed on several machines:

  • On the host server machine, change the log-in account of “Infor Cloverleaf(R) Integration Services” windows service to be a domain user.
  • On the host server machine, ensure the domain user is added into the same groups as those of local user hciuser.
  • On the SQL server database, create a new Windows authentication log-in user for the domain user.
  • On the specified Database of SQL Server, add a database user for the log-in user.

To configure a Windows authentication log-in user when SQL Server and CIS are installed on the same machine:

  • On the SQL server database, create a new Windows authentication log-in user for local user hciuser.
  • On the specified database of SQL server, add a database user for the log-in user.

To configure a database connection through the CIS client GUI, the database URL must be in this format: jdbc:sqlserver://server:port1433;DatabaseName=database;integratedSecurity=true.

During configuration, the user name can be any string, and the password can be empty.