When you attempt to enable/disable a receive location that uses WCF-SQL adapter, or when you attempt to start/stop a send port using WCF-SQL adapter you may experience this error "Failed to create 'WCF-SQL' Transport Component".


Failed to create 'WCF-SQL' Transport Component
Microsoft.BizTalk.ExplorerOM.BtsException: Failed to create 'WCF-SQL' Transport Component
   at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.SaveChangesWithTransaction(Object transactionObj)
   at Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.SaveChanges()
   at A.c5f8fe3d3ca28e5f96934744e075c6532.cf363711a3758a68242162aa434e00a35(ReceiveLocationCollection)
c8089c26347d4d0c5d5b248deacbe158a, ReceiveLocationOperation c5643bd14c28f75e668b81c80acad00)

   at Kovai.BizTalk360.BusinessService.Main.BizTalkApplicationBusinessService.ChangeReceiveLocationStatus (ReceiveLocationCollection receiveLocations, ReceiveLocationOperation operation)


This error will occur more likely, when you have installed BizTalk360 on a stand-alone server. To resolve this issue, install the BizTalk enterprise adapter pack (in this case WCF-SQL) in the server where BizTalk360 is installed.


You will face similar issue for other enterprise adapters like WCF-Oracle. So, if you are using any of the enterprise adapters, please install them on the server where you have installed BizTalk360.


You can also read this blog post BizTalk Admin only installation bug : Failed to create WCF-SQL Transport Component which helps to address this issue.