hp-support-head-portlet

Actions
Loading...

Welcome to HP Customer Support

hp-contact-secondary-navigation-portlet

Actions
Loading...

hp-share-print-widget-portlet

Actions
Loading...
  • Information
    Looking for Site Help?

    Learn about the features of the HP Customer Support site and how to use them to meet your online support needs. Click Here

     

hp-concentra-wrapper-portlet

Actions
Loading...

HP MFP Digital Sending Software Version 4.9x - External Database Configuration

Introduction
DSS can be configured to use an external database. This means that DSS will connect to a SQL Server database on another server, and the local instance of SQL Server Express 2005 can be uninstalled. The external database should be Microsoft SQL Server 2005 or later.
Configuring DSS to use an external database
  1. Install DSS 4.9x (make sure to uninstall any existing versions of DSS)
  2. After the installation completes, stop the following services:
    • HP Digital Sending Software
    • SQL Server (HPDSS)
  3. Export address books.
    • Open the DSS Configuration Utility.
    • Select the Addressing tab.
    • Click the Address Book Manager button.
    • Click the Export button, and save the addresses to a CSV file.
  4. Edit the SQL Server connection string.
    The database connection string is stored in an XML file and can be edited with a text editor.
    Open the following file in a text editor:
    [Install Path]\HP Digital Sending Software 4.91\FileSystems\Product\Dss\Configuration\ HP.Common.System.Data.config.xml
    There are three database configuration entries used by DSS which are contained in this xml file. These three entries are distinguished by the “add name” element, which has the values: Master, Machine and Customer.
    Each of these elements has a database connection string that can be edited to change the database that DSS and connected devices will use. The default database configuration entries are shown here:
    <add name=“Master”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=lpc:(local)\hpdss;Integrated Security=true;Database={0}”/>
    <add name=“Machine”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=lpc:(local)\hpdss;Integrated Security=true;Database={0}”/>
    add name=“Customer”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=lpc:(local)\hpdss;Integrated Security=true;Database={0}”/>
    The database connection strings must use the following format to be usable by the DSS Service and connected devices.
    connectionString=Server=YourHost.com\hpdss,5213; User ID=sa; Password=Hpdsdb000001; Database={0}
    YourHost.com
    IP address or hostname of the database server
    hpdss
    Instance of SQL Server on the target server to be used for DSS. If there is only one instance on the given SQL Server this parameter may be omitted. You may need to contact your Database Administrator for the appropriate instance name to use for DSS.
    5213
    Port number for communicating with SQL Server. Use the port number for your SQL Server. DSS 4.9x uses port 5213 by default.
    sa
    The User ID for connecting to SQL Server. This user should have necessary rights to create and delete databases.
    Hpdsdb000001
    Enter the Password for the selected User ID. This password will be used when connecting to SQL Server, and must comply with the password criteria established in SQL Server.
    {0}
    Database name to use for DSS. The value, {0}, will cause DSS to generate a default database name. If the database specified by this value does not exist, it will be created when the DSS service is started.
  5. Uninstall SQL Server 2005.
  6. Start the DSS service.
  7. Import address books.
    • Open the DSS Configuration Utility.
    • Select the Addressing tab.
    • Click the Address Book Manager button.
    • Click the Import button, and open the previously saved CSV file.
Important Notes
  • Each of the three connection strings can be edited independently to meet database installation needs and guidelines. Normally, the three SQL connection strings will be identical. However, there are cases where it is necessary to specify parameters differently for the Master, Machine and Customer databases. For example, the default database names for Machine and Customer (which store DSS specific data such as logs and address books) may be longer than allowed by SQL Server. In this case the connection strings may look like,
    <add name=“Machine”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=YourHost.com\hpdss;User ID=sa; Password=hpdss;Database=DSS_Machine”/>
    <add name=“Customer”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=YourHost.com\hpdss;User ID=sa; Password=hpdss;Database=DSS_Customer”/>
    <add name=“Master”
    providerName=“System.Data.SqlClient”
    connectionString=“Server=YourHost.com\hpdss; User ID=sa; Password=hpdss;Database={0}”/>
    The database name for Master should typically be left as Database={0}.
  • The SQL connection string used by the DSS server to establish communication with the database is also used by FutureSmart devices managed by DSS. When a device is added to DSS it receives the SQL connection string from the DSS server. Devices use the SQL database for storing the shared address books (i.e. email addresses entered directly on the device control panel).
  • Devices store the SQL connection string in an encrypted format to secure the access to the SQL Server database.
  • If you experience address lookup problems from the device control panel, there could be two possible problems which relate to the SQL connection string. First the network port used to access SQL Server may not be open in both directions from the device to the SQL Server on firewalls, routers, proxies, and other network equipment. Second, the device may not be able to authenticate to the SQL Server. Use the User ID and Password parameters to avoid authentication errors.
  • The “Integrated Security=true” parameter is not recommended in the SQL connection string when the database is not the default database installed by DSS. Use the User ID and Password parameters instead. Even though the Integrated Security parameter is valid for connecting to SQL Server, and provides slightly higher security, it may cause MFP device access to SQL to fail due to Windows authentication requirements.
  • Since the SQL connection string is used by FutureSmart devices, and the device receives this string when it is added to DSS, it is recommended to edit the connection string immediately after installing or upgrading DSS, before devices are added. If the SQL connection string is changed while FutureSmart devices are connected to DSS, they will not receive the new connection string until they are removed and re-added to DSS.

hp-feedback-input-portlet

Actions
Loading...

hp-online-communities-portlet

Actions
Loading...

Ask the community!


Support Forum

Support Forum

Join the conversation! Find Solutions, ask questions, and share advice with other HP product owners. Visit now


hp-feedback-banner-portlet

Actions
Loading...

hp-country-locator-portlet

Actions
Loading...
Country: Flag Romania

hp-detect-load-my-device-portlet

Actions
Loading...