HP Web Jetadmin - Using Microsoft SQL Server with HP Web Jetadmin
9
For SQL Authentication, cut and paste the contents of the following examples into the configuration
file for either a named instance or default instance, replacing the machine name, instance name,
database (catalog) and account credentials with the proper ones. Note that the plain text password is
encrypted in this file once the HP Web Jetadmin service is restarted so there is no compromise of
security. Because a user and password are present in the file, Web Jetadmin knows to use SQL
Authentication in the connection string to the SQL Server.
<ipmc:configuration xmlns:ipmc="www.hp.com/schemas/imaging/ipmc/config/2004/02/24">
<property name="DatabaseConnectionFactory.CommandTimeoutInSeconds">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>120</value>
</property>
<property name="DatabaseConnectionFactory.MachineName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert machine name here</value>
</property>
<property name="DatabaseConnectionFactory.UserName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert username here</value>
</property>
<property name="DatabaseConnectionFactory.PlainTextPassword">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert plain text password here</value>
</property>
<property name="DatabaseConnectionFactory.InstanceName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert named instance here</value>
</property>
<property name="DatabaseConnectionFactory.CatalogName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert database name here</value>
</property>
</ipmc:configuration>
Configuration file for remote SQL Server using named instance and SQL Authentication
<ipmc:configuration xmlns:ipmc="www.hp.com/schemas/imaging/ipmc/config/2004/02/24">
<property name="DatabaseConnectionFactory.CommandTimeoutInSeconds">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>120</value>
</property>
<property name="DatabaseConnectionFactory.MachineName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert machine name here</value>
</property>
<property name="DatabaseConnectionFactory.UserName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert username here</value>
</property>
<property name="DatabaseConnectionFactory.PlainTextPassword">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert plain text password here</value>
</property>
<property name="DatabaseConnectionFactory.DefaultInstance">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value></value>
</property>
<property name="DatabaseConnectionFactory.CatalogName">
<type>HP.Imaging.Wjp.Sdk.Core.Framework.ConfigurationItemString</type>
<value>insert database name here</value>
</property>
</ipmc:configuration>
Configuration file for remote SQL Server using default instance and SQL Authentication