Navision 3.7 on SQL 2000 Failover Setup

Dear All, I have a client who wants some form of Failover redundancy. ie: if one server is down the other would automatically take over. Have anyone tried using Windows 2003 Load Balancing or Legato’s Co-StandbyServer or any other third party software to achieve this??? Regards Bryan