SIM Database

[Fabrizio Maggioni_2]

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

[sandeep_raman]

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

[Fabrizio Maggioni_2]

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

[Aravindh Rajaram · Accepted solution]

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.

[Fabrizio Maggioni_2]

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

[Aravindh Rajaram]

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.

[Fabrizio Maggioni_2]

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.

[Aravindh Rajaram]

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

[Fabrizio Maggioni_2]

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