There are SATA converted official network adapters and there are third party SATA Network Adapters, which ironically don't have working network ports.
If you want to use SMB then make sure you get an official network adapter. Though really if you are going for SMB then a ps2 slim is much quieter.
I swapped from a fat ps2 with an internal drive to a slim over smb because of the noise (though back then I was also using SMS for watching movies).
I recently tried MX4SIO, but the one game I tend to play has major compatibility issues (you have to use a usb controller).