Symptoms
?K2? is automatically prefixed when username of a destination user is only provided even though ?K2SQL? is set as the default security provider.
eg.
Destination User value supplied = DENALLIXsqluser
Destination User resolved to = K2:DENALLIXsqluser
Diagnoses
This occurs when the username of the K2SQL user contains a "". K2 reads the "" as a domain user thus applying the 'K2' prefix. As for a K2SQL user without a "", 'K2SQL' is correctly prefixed.
Resolution
1. Manually prepend 'K2SQL' to the username of the destination or,
2. Change the username of K2SQL users to not use the [domain][user] format.