Server Management - Systems Insight Manager
1833698 Members
4686 Online
110062 Solutions
New Discussion

HP System Insight Manager 6.0 can not correctly move database to remote DB Server

 
nezeron
Occasional Visitor

HP System Insight Manager 6.0 can not correctly move database to remote DB Server

I tried to move from this manual, all work normal.
Now I have a problem:

1) snmp message not receive if DB on DB Servrer.
But if DB on local sql server all work.

2)I not can't turn off or delate local SQL Server becase hp sim connected for him when I move on remote DB Server.
*i see it from "Microsoft SQL Server Management Studio"

3) If DB on remote DB server and I change in HP SIM DB where I need connected
(more information where this change can see in manual) to DB on local SQL server
and then again change DB to remote DB server I see clean HP SIM.
But in local DB all information save correctly.

Configuration HP SIM PC:
Virtual Machine

Microsoft Windows Server 2003 R2
Enterprise Edition
Service Pack 2

Intel(R) Xeon(TM) CPU 2.80GHz
2.80 GHz, 1,47 GB of RAM


Configuration DB Server:
System:
Microsoft Windows Server 2003
Enterprise Edition
Service Pack 2

Itanium 2
1.50 GHz, 15.9 GB of RAM
------

User in local SQL and remote DB server is identical (domane user)
In local and remote DB this user have identical access rights in SQL Server.

In file HP SIM I change only "hp.Database.instancename", "hp.Database.hostName" and "connection-url"

original:
hp.Database.hostName=PC1
hp.Database.instance=PC1\\
<connection-url>jdbc:jtds:sqlserver://pc1:1433/Insight_v50_0_144054730;USENTLMv2=true;loginTimeout=20;domain=%domain%;instance=</connection-url>

after change

hp.Database.hostName=server1
hp.Database.instance=server1\\
<connection-url>jdbc:jtds:sqlserver://server1:1433/Insight_v50_0_144054730;USENTLMv2=true;loginTimeout=20;domain=%domain%;instance=</connection-url>

PS Install this version HP SIM because have SQL Server 2005 SP3 and not have licensing on SQL Server 2008 and need only monitoring and send sms if have problen

 

PSS sorry for write errors, English is not my native language.