FACT:HP SIM 7.x running on Windows 2008 R2 server as CMS/SIM server part of Windows domain

FACT:Windows 2008 R2 server

FACT:HP SIM 7.x
Questions/Symptoms

SYMPTOM:Upgrade from HP SIM 7.x to 7.3 failed without error on installer.

SYMPTOM:DB connection failed

SYMPTOM:SSPI handshake failed with error code 0x80090302, Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

SYMPTOM:Application got upgraded to ver. 7.3 but database not upgraded, While accessing SIM get DBconnection error.

SYMPTOM:Fresh Installation/upgrade to 7.3 failed without error on domain environment, where as in same environment HP SIM 7.2 installation work successful.
Cause

CAUSE:In Windows AD Security Options enabled for –
Domain user which is installation user for HP SIM, is not getting authenticated by AD while doing HP SIM 7.3 upgrade task; because of the Network Security enabled in Domain Group Policies.
Answer/Solution

FIX:To resolve this issue,
Note: Take backup of CMS/DB before execute any steps to be on safer side.CAUTION: Editing the Windows Registry incorrectly can permanently damage your computer. Follow these steps exactly to avoid damage, and consider consulting a professional if you are uncertain.

Workaround – If previous attempt to upgrade failed, uninstall HP SIM from Windows Control Panel, Program Features, uninstall HP Systems Insight Manager.
Install the HP SIM 7.2, point the older database with following steps:
1. Re-registration of a database by executing the mxreconfig command 

mxreconfig -m sqlredirect -s dbserver -b dbname -a dbuserDomain\dbuser -p dbport 
(The path for executing the mxreconfig command is as follows: 
<Installed Directory>\HP\System Insight Manager\mxreconfig\bin )
 -m (mode option – specifies reconfiguration mode) 
 -s (dbserver parameter - name of the new database server) 
 -b (dbname parameter - name of the new database) 
 -a (dbuser parameter - name of the database user with administrative privileges; must include domain name) 
 -p (dbport parameter - port number to access the new database server)

.
3. Stop the HP Systems Insight Manager Service, and modify the config files as follows
 
a. Open ‘hpsim-ds.xml’ in notepad from  <Installed Directory>\HP\Systems Insight Manager\jboss\server\hpsim\deploy
b. Add ‘useNTLMv2=true’ to connection-url line next to domain name
 
c. For example –

<connection-url>jdbc:jtds:sqlserver://CMS:1433/Insight_v50_0_8213175;loginTimeout=20;domain=CMS;useNTLMv2=true;instance=</connection-url>

 
d. Save the file and exit text editor.
 
e. Open database.admin  with notepad from <Installed Directory>\HP\Systems Insight Manager\config\
f. Add 'useNTLMv2=true' to databseName line and next to master.
 
g. For example- 

	hp.Database.authType=host
	hp.Database.databaseName=master;useNTLMv2=true;
	hp.Database.hostName=CMS
	hp.Database.instance=CMS\\
 
 
h. Save the file and exit text editor.
 
i. Open database.props  next file to database.admin with notepad.
j. Add   useNTLMv2=true to databseName line and next to HPSIM database name
k.  For example-

	hp.Database.charSet.en=UTF-8
	hp.Database.charSet.ja=SJIS
	hp.Database.databaseName=Insight_v50_0_8213175;useNTLMv2=true;
	hp.Database.dsn=Insight_v50_0

 
l.	Save the file and exit text editor


4. Start the HP SIM service and begin the upgrade process with Insight Manager 7.3 Installation Media.


In the installation user will get the result:
 
HP Systems Insight Manager - Successfully reused/upgraded components.