HP Web Jetadmin - Using Microsoft SQL Server with HP Web Jetadmin

11
configuration file for either a named instance or default instance, replacing the machine name,
instance name, and database (catalog). There is no need to have the sections containing user name
and password as was seen when using SQL Authentication. Without a user name and password in
the file, Web Jetadmin knows to use Integrated Security (Windows Authentication) in the connection
string to the SQL Server. Remember that remotely Web Jetadmin identifies itself as
Domain\Machine$ when Windows Authentication (Integrated Security) is used. In this case, make
sure the Domain\Machine$ account has dbo rights (read/write at minimum) on the database. If it
is desired to use a Windows User account instead of a Windows Machine account, the properties of
the Web Jetadmin service needs to be changed from Network Service to the Windows User account.
Once performed, Web Jetadmin identifies itself to the remote SQL Server as the Windows User
account. Therefore, make sure the Windows User account has dbo rights (read/write at minimum) on
the database. Remember, encrypted data such as global credentials are locked to the user/machine
account and would have to be re-entered.
<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.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 Windows 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.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 Windows Authentication