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