Figure 1. Add a Witness Server for High-Availability Mirroring
Configuring a mirrored database for high-availability operating mode requires configuring security for SQL Server 2005 principal, mirror, and witness instances. Principal and mirror instances must be Developer, Standard, or Enterprise Edition servers. The witness instance, which can be SQL Server Express to minimize license cost, should reside on a third machine to assure reliable automatic failover.