topic Re: SIM Database in Server Management - Systems Insight Manager

SIM Database

Fabrizio Maggioni_2 — Tue, 19 Sep 2006 10:16:02 GMT

Hi,

I have installed SQL SERVER 2005 (Standard Edition) and SIM (Version 5.00.01)
I want to use as database SQL SERVER 2005 and not MSDE.
During the installation of SIM,there is no option about it.
I would like to be sure that it is using the SQL 2005 one.
Can you support me?

I have already tried to connect to database via sql command (osql or sqlcmd) but with no result.(during installation i set "windows authentication mode and not mixed mode)
I can't connect via Enterprise Manager,becasue i don't have the depot to install.

Thanks,
Fabrizio

Solution: This problem is a result of not deleting or renaming the HP SIM database files from MSDE or Microsoft SQL Server after uninstalling HP SIM. Manually delete or rename the database files, and then run the HP SIM installation again

Re: SIM Database

sandeep_raman — Tue, 19 Sep 2006 10:50:20 GMT

Hello Fabrizio,

Does this help?
http://h20000.www2.hp.com/bizsupport/TechSupport/Document.jsp?lang=en&cc=us&objectID=c00760162&jumpid=reg_R1002_USEN

Afaik, typical/custom install should give an option to select the database.
If its not perhaps the above doc is valid.

SRH

Re: SIM Database

Fabrizio Maggioni_2 — Tue, 19 Sep 2006 10:56:50 GMT

Thanks.

But during the installation (typical),it does not ask about it.I check into the Installation Guide and seems that also using custom installation,there is no choice.

Sure that it ask about the parameters like database name, port, host but not about which type of database (SQL SERVER 2005 or MSDE)
I continue investigating.

Regards,
Fabrizio

Re: SIM Database

Aravindh Rajaram — Tue, 19 Sep 2006 11:16:32 GMT

You can just select the option named "Use SQL/MSDE". Enter the host name of ther server that hosts the SQL 2005 in the "Host" field and then select or enter the instance name (the default instance name is MSSQLSERVER), leave the rest of the values as it is and then proceed with the installation. Also, make sure that TCP/IP protocol is enabled for your SQL Server 2005 instance.

Re: SIM Database

Fabrizio Maggioni_2 — Wed, 20 Sep 2006 04:16:48 GMT

OK.
I configure like you suggest but now i am checking under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and i found out that the instance name is Insight_v50_0_761893.(not configured by me during the installation)

I am not sure SIM is using SQL server 2005 as database.
Can i do some tests?

Thanks.
Fabrizio

Re: SIM Database

Aravindh Rajaram — Wed, 20 Sep 2006 08:56:34 GMT

The instance name that you have specified is indeed created by HPSIM. You can acutally get to know all the HPSIM DB related info in a file named database.props that will be available under \config folder.

Re: SIM Database

Fabrizio Maggioni_2 — Wed, 20 Sep 2006 10:33:43 GMT

Hi,

This is my database.props file:

#--- Database Manager Properties ---
#Tue Sep 19 07:08:15 CDT 2006
hp.Database.authType=host
hp.Database.charSet.??=UTF-8
hp.Database.charSet.en=UTF-8
hp.Database.charSet.ja=SJIS
hp.Database.databaseName=Insight_v50_0_761893
hp.Database.dsn=Insight_v50_0
hp.Database.hostName=RMIN003
hp.Database.instance=RMIN003\\
hp.Database.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
hp.Database.jdbcUrlPrefix=jdbc\:jtds\:sqlserver
hp.Database.portNumber=1433
hp.Database.schemaFile_1=schema40.sql
hp.Database.schemaFile_2=DCSchema10.sql
hp.Database.schemaFile_3=schema40_41.sql
hp.Database.schemaFile_4=schema41_42.sql
hp.Database.schemaFile_5=schema42_50.sql
hp.Database.schemaFileCount=5
hp.Database.schemaFileNamePrefix=hp.Database.schemaFile_
hp.Database.schemaUpgradeFile=3
hp.Database.schemaUpgradeFile_1=schema40_41.sql
hp.Database.schemaUpgradeFile_2=schema41_42.sql
hp.Database.schemaUpgradeFile_3=schema42_50.sql
hp.Database.schemaUpgradeFilePrefix=hp.Database.schemaUpgradeFile_
hp.Database.sqlSchema=
hp.Database.ssl=off
hp.Database.username=RMIN003\\Administrator
hp.Database.vHandler=com.hp.mx.database.MsSqlVerificationHandler
MxVersionNumber=C.05.00.01.01

Is not clear if it is SQL SERVER 2005.
Do you hane any suggestion?

Thanks.

Re: SIM Database

Aravindh Rajaram — Wed, 20 Sep 2006 11:59:04 GMT

If your database host (RMIN003) has SQL 2005 alone installed on it then HPSIM makes use of SQL 2005 for sure.

Re: SIM Database

Fabrizio Maggioni_2 — Wed, 20 Sep 2006 12:11:00 GMT

OK.
Before installing SIM, i have installed on the same server the SQL SERVER 2005 Standard Edition (only binary).
My doubt was the installation of SIM, install and confiure like its database the MSDE one.This because seems that SIM depot include also MSDE component.
But now with your help and some check i am sure that it not use the MSDE one.
We can close the case.

Thanks a Lot.
Fabrizio