HP Web Jetadmin - Using Microsoft SQL Server with HP Web Jetadmin
20
for SQL is not supported at this time. The mirrored configuration is only supported if the remote
database option has been licensed.
The following parameters can be added to the DatabaseSettings.config.xml file to support failover for
mirrored SQL configurations:
DatabaseConnectionFactory.FailoverPartner.MachineName—the mirror partner for the database
DatabaseConnectionFactory.FailoverPartner.InstanceName—the instance name of the mirror
partner database
DatabaseConnectionFactory.FailoverPartner.DefaultInstance—forces the default instance of the
mirror partner database to be used
<ipmc:configuration xmlns:ipmc="www.hp.com/schemas/imaging/ipmc/config/2004/02/24">
<property name="DatabaseConnectionFactory.FailoverPartner.MachineName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>db2.SomeDomain.com</value>
</property>
<property name="DatabaseConnectionFactory.FailoverPartner.InstanceName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>HPWJA_MY_INSTANCE</value>
</property>
<property name="DatabaseConnectionFactory.CatalogName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>HPWJA</value>
</property>
<property name="DatabaseConnectionFactory.InstanceName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>HPWJA_MY_INSTANCE</value>
</property>
<property name="DatabaseConnectionFactory.MachineName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>db1.SomeDomain.com</value>
</property>
<property name="DatabaseConnectionFactory.PlainTextPassword">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>MyPassword</value>
</property>
<property name="DatabaseConnectionFactory.UserName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>MyDBUser</value>
</property>
<property name="DatabaseConnectionFactory.CommandTimeoutInSeconds">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>120</value>
</property>
</ipmc:configuration>
Figure 14—Example DatabaseSettings.config.xml file for using a mirrored database