In the Connection Manager for your SQL Server you must set RetainSameConnection=True. This is what we did in our project, but we could not get it to work for...