communication between biztalk server & SQL server

I think it’s just 1433 but you also might need 135 and 5000-5020. I think you need them all is you are using the sql adapter.

See help guide under Ports for the Receive and Send Servers, Ports for the for more info.