"max_packet_size" variant in SQL Server
See Configure the network packet size Server Configuration Option:

sp_configure 'network packet size', ...;


But this setting is not the same as MySQL's max_allowed_packet, is more similar to net_buffer_length. SQL Server's maximum request limit is 65,536 * Network Packet Size, which is closer to max_allowed_packet meaning.