Basic Steps of Installation SM with SQL Server

Any HP Service Manager developer will undoubtedly see the value in a local installation of the software. This article will give you a clearly steps about that. So, let see:

Pre-Installation Requirements

Before setting up your local HPSM installation, you will need to download some software packages.

Microsoft SQL Server . You will need the edition with the client tools in order to configure your database. Select either the 32-bit or 64-bit edition as required by your operating system.

On our production, we are using SM 9.4x with SQL Server 2014.

HP Service Manager 9.40 English SW E-Media – The core application is available from HP’s Software Support Website. You will need your Support Authorization ID (SAID) number from your HP order.

Installing and Configuring the Database

The database should be installed before the other components. The HPSM configuration process will require an configured, empty database to be available. This section assumes that you do not currently have a SQL Server instance installed on your local system.

  1. Launch the Microsoft SQL Server 2008 Express with Tools installer. You may be prompted with a compatibility warning which is safe to ignore at this time. We will reconcile that later.


SQL Server Installation Center

  1. From the SQL Server Installation Center, select the Installationmenu.
  2. Select the New SQL Server stand-alone installation… option.
  3. On the Feature Selectionscreen, click the Select Allbutton.


SQL Server Feature Selection

  1. On the Instance Configurationscreen, select Default Instance.
  2. On the Server Configurationscreen, click the button labeled Use the same account for all SQL Server services.
  3. In the Account Namedrop-down, select NT AUTHORITY\NETWORK SERVICE.


SQL Server Configuration

  1. Leave the Passwordfield blank and click OK.
  2. On the Database Engine Configurationscreen, select Mixed Modeauthentication and select a password for your system administrator (sa) user. Also, click the Add Current User button at the bottom to ensure that you will be able to configure the SQL Server via your Windows account later.


SQL Server Database Engine

  1. Complete the installation wizard.
  2. Once the installation wizard completes, run your Windows Updateservice to download the latest SQL Server Service Pack. This fixes the compatibility warning you may have been presented with in Step #1.
  1. Launch the SQL Server Configuration Manager(Start->All Programs->Microsoft SQL Server 20xx ->Configuration Tools).
  2. Under SQL Server Network Configuration, select Protocols for SQLEXPRESS.
  3. Right-click the TCP/IPprotocol option and select Enable.


SQL Server Configuration Manager

  1. Select SQL Server Services.
  2. Right-click the SQL Server (SQLEXPRESS) service and select Restart.
  3. Launch the SQL Server Management Studio(Start->All Programs->Microsoft SQL Server 2008).


SQL Server MS Connect

  1. In the Server Namefield, enter localhost\SQLEXPRESS.
  2. Select SQL Server Authentication.
  3. In the Loginfield, enter sa, and enter the password specified in Step #9.
  4. Once connected, right-click the Databasesfolder in the Object Explorerand select New Database…


SQL Server New Database

  1. In the Database Namefield, enter a name for the Service Manager 9.20 database (e.g. sm920).

Configuring ODBC Data Source

HP Service Manager connects to the database via an ODBC Data Source Name (DSN). Next, we will configure a DSN that will be used to connect your HPSM application to the database you just created.

Note: Instructions for this are different for 32-bit and 64-bit Windows. You will need a 32-bit DSN for HP Service Manager.

32-bit Windows

Launch the ODBC Manager by selecting Start->Control Panel. Then Administrative Tools->Data Sources (ODBC).

64-bit Windows

Click the Start button and, in the Search programs and files box, enterc:\windows\sysWOW64\odbcad32.exe. You should see odbcad32 in the program list. Click the icon.

From this point on, directions are the same.

  1. Select the System DSNtab and click the Add…button.


Create ODBC Data Source

  1. Select the SQL Serverdriver and click Finish.
  2. Enter a name for the data source (e.g. sm920) and localhost\SQLEXPRESSas the Serverand clickNext.
  3. Select the With SQL Server authentication…option. Enter saas the Login ID and the password specified in Step #9 and click Next.
  4. Check the Change the default database tocheck box and select the database you created in Step #22.
  5. Click Nextthen Finish.



  1. Make sure that your DSN is going to work correctly by clicking the Test Data Source…button.

Installing the HP Service Manager 9.20 Server

Once the database and data sources are both set up properly and you’ve been able to establish an ODBC connection via the test, you are ready to install and configure the HP Service Manager server.

  1. Open the HP Service Manager 9.20 English SW E-Media and browse to the Server\Windowsfolder.
  2. Right-click the setupserverapplication and click Properties.


HPSM Server Compatibility

  1. On the Compatibilitytab, check the Run this program in compatibility mode for…check box and select Windows Vista (Service Pack 2). Also, check the Run this program as an administrator check box.
  2. Click Applyand OK.
  3. Double-click the setupserverapplication to launch the HPSM server installation wizard.


HPSM Server Install

  1. Select the default options through the wizard, and on the final screen, select the Run the configuration program after installcheck box and click the Finishbutton.

Configure the HP Service Manager 9.20 Server

First of all, we need to get a permanent license for HP SM or we can enable 60-day trial as temporary license.

In order to enable trail license, go to the <<HP SM home folder>>\run\sm -instanton

In order to enable permanent license, you can request a permanent Service Manager license from the following URL: managed with AutoPass. To request perpetual license passwords, you need the following items: • Entitlement Certificate, which contains the HP product number and order numberServer Installation 65 • IP address of the server • Your company or organization information A permanent license is tied to your server’s IP address and requires you to place a copy of your license file (LicFile.txt) in your server’s RUN directory. The default value is: licensefile:<Service Manager server installation path>/RUN/ LicFile.txt You may specify a different license file path with the licensefile parameter. For example: licensefile:c:/common/LicFile.txt If your sever obtains an IP address from DHCP, you may have to request a new license that matches the server’s new IP address. You can also contact the HP Password Center by using fax, E-mail, or phone. This information is available on the Password Request Form and the License Entitlement Certificate. To obtain product licenses, you need the License Entitlement Certificate.



Saving your license key/password file to your system

As part of the process of obtaining a permanent AutoPass license, a .dat file or several .dat files were sent to the E-mail address that you provided. These files contain the licensing data required to use the applicable Service Manager modules. After you receive these files, you must move them to the Service Manager server. Follow these steps to save your license key/password file to your system:

1 Rename the .dat file to a .txt file so that you can open it with a text editor. Example: from J8888X1624204.dat to J8888X1624204.txt

2 Create a file, LicFile.txt, to store the license data in. The default location for this file is: <Service Manager server installation path>/RUN/LicFile.txt

3 Copy the license data from the license file and paste it in the LicFile.txt you created.

The HP Service Manager Configuration appears, and we are ready to configure the server settings as well as install the core application structure and data into the database.


HPSM Configuration

  1. Select the default HTTP Port (13080). You may select a different port if necessary for your installation (i.e. if you already have another service or application running on port 13080).


HPSM Config DB

  1. On the Database Type and Connection Informationscreen, enter the name of the DSN that you specified in Step #25. The Useris sa and the Password is the password that you specified in Step #9.
  2. On the next screen, click the Verify Connectionbutton to ensure that the database link is working properly. If the connection cannot be made and you are sure that the service is running, ensure that you used the correct method (32-bit or 64-bit) for creating the ODBC DSN as specified previously.
  3. The next screen is the HP Service Manager Application and Demo data uploadscreen. Click theUpload Databutton to populate the database. This process may take several minutes to complete.

The upload can cause some problem issues concerning to the upload


After investigating the smconfig.log log file à caused by there are a lot of IPs available on the machine. We need to disable all and leave only one IP for this purpose

Run à ncpa.cpl à disable the IPs, leave the primary network card’s IP

Then run the configuration again à it works

  1. Complete the configuration wizard, and your HP Service Manager 9.xx server is ready to launch.
  2. Start the HP Service Manager 9.xx Serverservice via the Windows Service console.

Install the HP Service Manager 9.xx Windows Client

Now that your HP Service Manager 9.xx Server is ready to use, you’ll need a client to connect to it.

  1. Open the HP Service Manager 9.xx English SW E-Media and browse to the Client folder.
  2. Right-click the setupclient application and select Properties.
  3. On the Compatibilitytab, select to run the program in compatibility mode for Windows Vista (Service Pack 2). Otherwise, visual problems with Windows 7 Aero and the installer will prevent controls like buttons and check boxes to display properly.
  4. Launch the setupclientapplication and select the default values for the wizard.
  5. Once the installation is complete, launch the HP Service Manager client.
  6. In the Connections dialog, click the New launch configurationbutton.
  7. Enter the information to connect to your local installation. The Server host nameis localhost, and the port is 13080(unless you specified a different value in Step #36). Initially, use the user name falcon with a blank password to make your initial connection.
  8. Click Connect.

Install Tomcat 

Then copy the WAR file into the webapps folder à start the Tomcat 6 in order to install the application.

Then edit the web.xml under folder WEB-INF to match with our environment

secureLogin true Controls the encryption of network communication between the web application server and the web browser. Set it to false if you do not use Secure Sockets Layer (SSL) connections to the web server.

Note: To use secure login, you must enable SSL on your web application server. For details, refer to your web application server documentation.

I recommend for the first use, you need to set it false

sslPort 8443 This parameter is needed only when secureLogin is set to true. Set it to the SSL port of the web application server.
serverHost localhost Specifies the name of the Service Manager host server.
serverPort 13080 Specifies the communications port number to which the Service Manager server listens.

Set other common parameters as desired. The table below lists the commonly set parameters and their default values.

Parameter Default value Description
cacerts WEB-INF Lists the path to the CA certificates required for SSL support.
compress_soap true Specifies if you want to use data compression between web clients and the web tier.
helpServerHost localhost Specifies the name of the Help Server.
helpServerPort 80 Specifies the communications port number to which the Help Server listens.
helpServerContext help Defines the context path when deploying the Service Manager help on a web server (for example, Apache).

The context path refers to the virtual directory name where the Service Manager help is installed. It excludes the web server’s document directory path. For example, if the help is deployed in C:/Apache/2.2/htdocs/sm_help, the document directory path is C:/Apache/2.2/htdocs/ and the virtual directory name is sm_help. Therefore, the context path is sm_help.

Note: This parameter is supported only for Service Manager 9.30p1 or later. For version 9.30, the help must be deployed in the “help” virtual directory (for example, C:/Apache/2.2/htdocs/help).

showHelp false Enabling this parameter causes Web clients to display the Help button, which allows users to access the Help Server you define in the web.xml.
refreshMessages true Determines whether the browser checks for new messages from the application server.
refreshMessagesInterval 15000 Determines how often (in milliseconds) the browser checks for new messages from the application server.
ssl false Enables the web client to encrypt communications using the server’s demonstration certificate.
viewactivenotes false Determines whether you see a pop-up message when the server sends a message.


Endorsed JAR files are no longer required. If you installed them in previous installations, remove them


Access SM by using web client

To connect to Service Manager by using a browser:

  1. Use the following URLs to access Service Manager from the web tier.
    For <server>, type the name of the web server running the web tier.
    For <port>, type the communications port number used to connect to the web tier.

Note: If you deployed using the webtier-ear-9.xx.ear file, you can find the webtier-9.xx.war file archived inside the .ear file.

  • Standard web client: http://<server&gt;:<port>/webtier-9.xx/
  • Employee self-service web client: http://<server&gt;:<port>/webtier-9.30/
  • Accessible web client: http://<server&gt;:<port>/webtier-9.xx/ The accessible web client does not display record lists.
  • Accessible employee self-service web client: http://<server&gt;:<port>/webtier-9.xx/

Note: You do not need to specify the communications port in the web tier URL if you use the default web server port (port 80). See your web server documentation for instructions on setting the communications port. But I recommend you to choose another port with 80 (i.e 8080).

  1. Enter the following information:
    • User name: The user name that you use to log in to the server.
    • Password: The password that you use to log in to the server.
    • Language: The language to use for this session (can differ from the language set on the computer).

Note: The login account that you enter must already exist in Service Manager. Service Manager provides an out-of-box login account with System Administrator privileges: System.Admin (with a blank password). HP recommends that you disable this account or change its password after creating accounts for all of your users. For information about how to create user accounts, see the Service Manager help.

  1. Click Log In.

Note: After logging in, do not use the buttons (such as Refresh, Back, and Forward) on your browser toolbar or their keyboard shortcuts (such as Ctrl+R, Ctrl+Left, and Ctrl+Right) to perform Service Manager actions. Instead, use the buttons on the Service Manager interface.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s