Probably SQL adapter is one of the most used BizTalk adapter; its only when u use it ; u find out its limitations.One such error I came across while importing binding file to setup ports for SQL adapter
Error: Failed updating Binding information.BindingException: Could not validate TransportTypeData or Address properties for Primary Transport of Send Port 'ReceivePortName'.Exception from HRESULT: 0x80131500
After googling a bit for possible causes and resolution; I found my solution.The trick to fix this is u need to absolutely sure that from Biztalk server machine you can access SQL server
1. Check if user account running BTS Application Host has enough rights to SQL server
2. Open the binding file change the password=************** to password=yourpassword
More information at http://www.faqts.com/knowledge_base/view.phtml/aid/35313/fid/1783
3. If your running BTS or SQL or both on Virtual Machines then check for connectivity
http://www.winterdom.com/weblog/archives/000496.html; this fixed problem in my case
4. If SQL server and BTS are on different machines then it may be worthwhile to check DTC settings
set DTC to “no authentication required“; this may compromise your security though
5. Install BTS SP1
Cheers
Vishy