Resolution:
Description:
============
When installing a new version of the TIBCO iProcess Engine [iPE] or upgrading an existing iPE node to use SQL Server Windows authenticated logins, there are a few factors to be aware of:

- The version of iPE you are using.
- What options you select on the "SQL / ODBC Details" window of the installer.

Environment:
===========
   o Windows 2000, Windows 2003, Windows 2008
   o TIBCO iProcess Engine (SQL) - v11.1.1.8


Symptoms:
========
When using SQL Server logins which are Windows authenticated for the iPE database logins on the "Database Details" dialog window of the installer, a "User 'x' does not exist. Do you want to create it?" popup message is displayed.


Cause:
=====
This is a bug that was introduced in the iPE version 10.6.0 .  Any users attempting to upgrade or install iPE will receive this message if they use SQL Server Windows authenticated logins.  


Resolution:
==========
- An 11.1.1.8 or later version of iPE must be used to successfully install a node that utilizes Windows authenticated users within SQL Server.

- Prior to the 11.1.1.8 version of iPE, the checkbox for "You have DBA privileges (to create a database and users)" could be used to successfully install an iPE node that utilizes Windows authenticated logins to SQL server.  From version 11.1.1.8 and up, this checkbox must not be used as it will lead to the creation of SQL Server authenticated users for use in iPE rather than Windows authenticated users.  

References:
==========
Make sure to follow the 'TIBCO iProcess Engine (SQL Server) for Windows’ installation guide when performing a new install or upgrade.

Installing or upgrading TIBCO iProcess Engine (SQL) using SQL Server Windows authenticated logins.