PMP database installation to remote SQL server

[Scott White_5]

I installed SIM 5.0 yesterday to replace our aging CIM 7 system. It was installed using a remote SQL server database with Custom install using a domain account with SA access on the remote DB server. SIM created the Insight manager database without problem. However, when I got to the PMP installation I was unable to install it because the service account credentials were incorrect and I was unable to change them. Specifically, the Domain was incorrect - instead of the domain (DomainX) it was pointed to the local server (SimServer). The login account and DBServer name were correct.

I've searched the forum and checked every file I could on the system to try and discover where the PMP installation was getting the data to populate the credentials but had no luck.

Does anyone know how I can change the domain in the credentials screen so that PMP is able to install?

TIA,
Scott

[Rob Buxton]

Where was the HPSIM Database itself located?

Did you select a typical install or did you install items separately?

When I installed HPSIM it installed bot the HPSIM and PMP database fine.

[Scott White_5]

The SIM database is located on a remote SQL server. I did a Custom installation with both SIM and PMP checked. That's why I am so surprised since the SIM database was created without problems on the remote SQL server I would have thought that PMP would have too.

Scott

[Rob Buxton]

Yes, that is odd behaviour.
I installed HPSIM 5.0 using the Typical installation. I also use a remote database and that worked okay.
You could try manually installing PMP.

[Scott White_5]

Yes, I have tried running the PMP.exe setup program manually under both Domain and Local administrative accounts. The "Domain" field always has the local server name as the value (greyed out) instead of the actual domain.

It must be pulling this value (along with Username, and DB server name) from some location either in the registry or in a file to populate the setup dialog. If I can figure out where it pulls that data from hopefully I can edit it and get the installation to run.

Scott

[Scott White_5]

I played around with it a little bit more and finally found the file where the setup program for PMP was pulling the "Domain" value.

There is a line in the C:\Program Files\HP\Systems Insight Manager\config\globalsettings.props file

WindowsInstallUserName=ServernameXYZ\firexxxx

This line is created during the installation of SIM and is set to the logon account used during the installation. (I used the account above during installation, it is a local system account with admin privleges).

Changing this line to "WindowsInstallUserName=DomainXYZ\firexxxx" changed the "Domain" value in the PMP configuration setup to use DomainXYZ instead of ServernameXYZ which let me complete my installation of PMP. Note firexxxx doesn't even exist the domain - the installation was pulling the user name from another file (I assume one of the DB props files).

Why HP would pull the Domain information for the PMP setup from this line is beyond me as they were obviously pulling the user account and database server name from one of the database props files and should have been pulling the domain info from the same place. Or even better - allowing the user to edit those fields/values during the installation.

Thanks for the responses!
Scott