Current versions of mIRC require you to have sounds on in order to hear any sound, custom or default.
You could use a script like this
Code:
on *:open:?:*:{
  .splay <wav_file>
}
on *:text:*:?:{
  if $query($nick) != $active {
    beep
  }
}