You should be able to get it to play using standard SB setting for audio. I think it is SB Pro, 5, 1, 5. Regardless you probably won't be able to run it in high resoultions. The only resolution I can get out of any Build engine game is 320x200.

Redneck Rampage is based on the "Build" engine which means that anything above 320x200 resolution is a no-go, SoundBlaster audio will work in XP but it will be very poor (you have to have set to a low quality level with as few voices as possible or your video will have seizures), and it also means VDMSound is not a solution.
 
You could try that hack that comes with SoundFX (Cli2Nop), but that will make the game unstable. Right now, your best bet is to run this on a Win9x machine. Dual-booting between Win9x and XP works best for me.