New install of SIM 5.1 fails to contact database

[Jari L.]

Hi,

I tried to install SIM 5.1 on a newly installed XP workstation. I also have a dedicated SQL server for storing the SIM database. Installation documentation says that it is possible to install sim 5.1 on a windows XP.

The problem is that installation program claims that the user has insufficent rights to the database even it is not the case.


Here is the installation log.

[Wed Jan 31 09:40:01 UTC+0200 2007]Install Shell:inspectSystem()
[Wed Jan 31 09:40:01 UTC+0200 2007]Install Shell:installPreInstallComponents()
[Wed Jan 31 09:40:01 UTC+0200 2007]Install Shell:checkForPreviousHPSIM()
[Wed Jan 31 09:40:01 UTC+0200 2007]Install Shell:IsValidOracleServer()
[Wed Jan 31 09:40:01 UTC+0200 2007]Install Shell:IsValidSQLServer()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:Load: res://C:\install\hpsim5.1\SIM51-win\hpsim\win_ia32\setup.exe/content\account-credentials.htm
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:buildDocumentationSelect()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:window_onload()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:isDefaultInstanceName(instName[HPSIM])
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:populateInstanceSelectionType()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:getSQLInstances()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:populateDBInstances()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:btnMSDE_onclick()
[Wed Jan 31 09:40:02 UTC+0200 2007]Install Shell:customInstanceNameClick()
[Wed Jan 31 09:40:08 UTC+0200 2007]Install Shell:btnSQL_onclick()
[Wed Jan 31 09:40:08 UTC+0200 2007]Install Shell:populateInstanceSelectionType()
[Wed Jan 31 09:40:08 UTC+0200 2007]Install Shell:getSQLInstances()
[Wed Jan 31 09:40:08 UTC+0200 2007]Install Shell:populateDBInstances()
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:btnNext_onclick()
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:saveDBType()
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:validDBInformation()
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:CheckDBServer(fnComplete[function])
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:IsWinXP()
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:isDefaultInstanceName(instName[MSSQLSERVER])
[Wed Jan 31 09:40:32 UTC+0200 2007]Install Shell:CheckDBHost: cmd /c cd C:\InstallTemp & set JAVA_HOME=.\jre & set PATH=.\ & .\jre\bin\java -cp ".;.\jtds-1.0.2.jar" sql/SQLServer -h "SQLSERVER" -pn "1433" -db "insight" -u "%100%100" -dm "DOMAIN" -debug
[Wed Jan 31 09:40:33 UTC+0200 2007]Install Shell:CheckDBServerComplete()
[01-31-2007][09:40:38][Install Shell]Insufficient rights to database.
[Wed Jan 31 09:40:38 UTC+0200 2007]Install Shell:CheckDBServerCompleted(dwRet[128])
[Wed Jan 31 09:40:38 UTC+0200 2007]Install Shell:populateInstanceSelectionType()
[Wed Jan 31 09:40:38 UTC+0200 2007]Install Shell:getSQLInstances()
[Wed Jan 31 09:40:38 UTC+0200 2007]Install Shell:populateDBInstances()

[cbsaunders]

Hi Jari - This was some time ago, so I'm assuming you got beyond the error? I'm having a similar problem trying to install using a distince SQL database server and instance. Did you find a solution to your issues, and if so, do you mind sharing how you got it to work?

Thank you!

[Alex HU]

Hi People,

This is a known issue and it is solved within SP1 for SIM 5.1. You can download the newest version of 5.1 and sp1 from the sim homepage.

greets,

Alex

[PCA_2]

Hi there.

I'm trying to install the 5.1SP1 on a win2K3 and pointing to a different server (win2K3) where the DB is stored (with SQL2005) and having this same problem...
:(