BAM Web Services and SQL Server mixed mode authentication

In BizTalk Server 2006 BAM webservice does not work with SQL Server using Mixed Mode Authentication as written by Tihot He also explains how to diagnose this problem apart from giving solution to resolve it.
Good Work!