SIP Filter Failover Connection String

In order to define a fail-over partner in the SIP Filter, you just need to add the following somewhere within the connection string (anywhere after Data Source and before Password): “Failover partner=”

For example, if this is the full connection string without the fail-over partner:

connection-string: Data Source=SQL.Domain.com;Initial Catalog=AccessPortal;Persist Security Info=True;User ID=AccessPortalUser;Password=P@ssW0rd

Then with the failover partner, it would look like this:

connection-string: Data Source=SQL.Domain.com;Initial Catalog=AccessPortal;Failover Partner=SQL2.Domain.com;Persist Security Info=True;User ID=AccessPortalUser;Password=P@ssW0rd