Description:
When SQL Server 2005 is used with TIBCO BusinessWorks Collaborator (BWC) and you sync Workflow Users from TIBCO ActiveMatrix Administrator(Admin) to BWC servers, the first sync succeeds but every subsequent sync fails. The second time you sync, this error is thrown in the Administrator console - "User Not Authenticated.: Failed to logon to Workflow server as icdba : User Not Authenticated..".



Symptoms:
When SQL Server 2005 is used with BWC and you sync Workflow Users from TIBCO ActiveMatrix Administrator (Admin) to BWC servers, the first sync succeeds but every subsequent sync fails. The second time you sync, this error will thrown in the Administrator console - "User Not Authenticated.: Failed to logon to Workflow server as icdba : User Not Authenticated..".

WF user/role synchronization from Administrator to BWC fails on subsequent tries.
Cause:
By default, the DB created for ICDB is with ANSI_PADDING set to FALSE.  If the ANSI_PADDING is set to TRUE, the next time synchronization is tried for users/roles, synchronization will fail with the ICDBA user not being authenticated. "User Not Authenticated.: Failed to logon to Workflow server as icdba : User Not Authenticated.."

If ANSI_PADDING is set to TRUE, passwords stored in the DB are padded with spaces resulting in a mismatch between the passwords stored in Admin and BWC DB.