does the vendor support using a DNS alias in the connection string? If so and automatic failover is not vital to you you can still use mirroring in high performance mode or high safety without automatic failover