New v5 install - Database "invalid credentials"

[Jonathan Clark_2]

ITS WORKING.....Here are the steps

Created local admin account called insightmgr. The password was simple and did not include any special characters, only letters and numbers(all lowercase)

logged off and back on under this new admin account(Local only).

installed MSDE that came with SIM using the following options:

DISABLENETWORKPROTOCOLS=0
REBOOT=ReallySuppress
SAPWD="same as account created above"
INSTANCENAME="InsightMgr5"

Rebooted computer
Logged back in under local account.

Ran svrnetcn to change port number on that instance of msde to 1453.(This gets me past the "Invalid Credentials" error I mentioned in some other posts)
Restarted SQL

Ran typical install and put in the credentials for the local account I was logged in as.

Changed port number and instance name to match.

Computername\InsightMgr5
Port: 1453

Clicked next and watched the install... It worked fine. :-)

[Darrin Rawls]

Awesome, thanks. One thing to note, his post is around using MSDE as a named instance (i.e. something else is installed on the server with MSDE); won't help if that's not the scenarios you are installing under.

We are also seeing a Domain Policy/Local Policy getting in the way of authentication - there are 2 under Security Options called "Network Security:LAN Manager authentication level" and "Network Security:Minimum session security for NTLM SSP Based..". Make sure for the first one basically, donâ t require NTLMv2 and donâ t refuse it. For the second one make sure it is set to "No Minimum"/

If anyone has anything set differently, post out.

thanks!

[Preston Gallwas]

We've got no policies applied to the box...but to verify those, I'd check locally on gpedit.msc ??

Also, how is it that you folks are using typical install and able to edit the account that you can log in with? I cant edit that field!!!

[Darrin Rawls]

The differing account names around around upgrades mostly, fyi.

SIM's installer uses the installed user account (i.e the OS account) that you are logged in to do all the connections. In the interest of keeping things simple, we default to this. There are many things to setup with the account and such and that makes it easier. FYI.

Maybe we need to revisit editing the user account (but this could be a different account setup for SSH, etc. than the logged in account) so additional post install setup might have to be done in that case.
:(

[Jeff Peil]

I have the same issue.
New install of Windows 2003 SP1.
New install of SIM 5.0 went like this:
1. Install MSDE (went fine)
2. SIM install starts, choose Typical
3. Username and domain fields greyed out.
4. Enter the password, "Invalid Credentials"

The account I am logged in as is a domain admin account, just MSDE default install.

This domain account password does have special characters. Has this been determined to be an issue?

[Darrin Rawls]

Depends, what type of characters?

[Jeff Peil]

Ok, so I assume there are characters you cannot use. Can those perhaps be listed so as to enlighten those of us who do not know them?

[Jeff Peil]

Ok, I tried a much simpler password that does have an "@" and a "!" in it...and it worked!

My previous password had this character which could be the problem:
"+"

[Preston Gallwas]

I tried a simple password, and the install worked.

I'm having trouble *RESETTING* the password (we have a standard administrator password for the local servers here) and getting the MSDE to trust administrator when the password changes

hrmp. Any tips on that?

[Dmitry_70]

That seems like Java login exception. The JRE 1.5 has being installed with new HP management software like HP ProCurve Manager 2.0 or HP SIM 5.0 is not working in W2k3. For example, the web page of my ProCurve switch come to work correctly only after I installed the out-of-box JRE 1.4. Before this my IE reported me somthing about Java incompatibility.
The "invalid credentials" is not the only issue I have during SIM 5 install. After the "Service Account Credentials" dialog of the installation wizard I got an event in the System Event Log from the SCM source: "The AdminTest service terminated with specific error 123456".
I guess the JRE 1.4 installation might resolve the problem. I'm going to install JRE tomorrow.

[Darrin Rawls]

HP SIM 5.0 no longer uses client side Java though - don't need it.

[Joel Rubenstein]

the "Service Account Credentials" dialog of the installation wizard I got an event in the System Event Log from the SCM source: "The AdminTest service terminated with specific error 123456

This is the normal return status from the admintest.exe program which is used by the installer to validate the service account credentials.

[Dmitry_70]

Really? I'm newbie in the HP management software, excuse me. So why Java was installed with SIM? May be it was installed with Open SSH or WMI Mapper, which are parts of the full SIM suite?
Moreover, I see a temporary folder created by the SIM installer with Java executable files and above-mentioned AdminTest.exe is located in this folder.
In any case thanks to Darrin and Joel. And excuse me for my poor English...

[Dmitry_70]

Excuse me, Darrin, one more question. May be HP SIM 5.0 no longer needs client side Java, but what about SIM installer? Look at the attached picture, please.
For which database validation JVM has being extracted? Is it means the Database Configuration dialog or not?

[Todd Henderson_2]

Ok,

I beat my brains out on this issue as well and after piecing together bits from all of these posts I finally fixed it.

I was trying to upgrade from v4.2 to v5.0 with MSDE locally installed and using a local service account. I kept getting the invalid credentials error as well.

In addition, our domain had the Network Security: LAN Manager Authentication Level set to "Send NTLMv2 Responses Only". In addition, the Network Security: Minimum Session Security for NTLM SSP....was set to NTLMv2 only as well.

So, this is what I did:

1. Disjoined the workstation from the domain (to get around the network policies).

2. Set the password on the service account to a simple one.

3. Logged in with the service account and changed the default port to 1453 and rebooted.

4. The "invalid credentials" message went away and I upgraded to v5.0.

5. After the upgrade completed, I joined the workstation back to the domain and changed the password back. (This required me to change the pwd on all the services as well).

6. Rebooted one last time and all was well.

Whew! I hope that helps. The security policies will absolutely stop the install if they are set. (Note: This disjoining domain part is only valid if your domain policy sets the Network Security Policies).

[Dmitry_70]

Just now I tried to point to another (remote) database and enter another user account with simple password contains letters only. It solved the problem :(. What should I do? Can I break current SIM installation, change my pass and start the installation again? Can I change the password back after installation and enter old password value? Is the password required for service "Log on as" setting ONLY?

[tmagee]

No solution from me but just wanted to add that my install of sim 5.0 gives a similar error of invalid credentials. I already have sim 4.2 and MSDE installed on the same unit.

Tried "Typical install" and "custom install" options but both complain about not finding the host where msde is and incorrect password. Custom install also isn't able to install the homepage and gives an error on installin the WMI mapper. I've not tried changing the port setting recommended earlier or the other suggestions yet. The unit I'm installing sim 5.0 on is a workgroup with only itself on it and not part of a domain.

[Todd Schelin]

I have tried everything that has been listed in this post and still have no luck.

I am running MS SQL Server on my SIM Server and not MSDE. What is the deal?

I still get the "Invalid Credentials" error.

Has anyone, "HP" got a solidified solution to this problem if you are running MS SQL Server. This is getting very irritating and seems like it should have been easily fixed.

The only thing I did not do was disjoin my server from the Domain. I think that would be something I should not have to do.

Please any additional help would be great. I upgraded to from SIM 4.2 to SIM 5.0 and have yet to get PMP to install...

[Aravindh Rajaram]

Are you running a named instance of SQL server 2000?

[Todd Schelin]

No it is just the name of the server. I just left the default when I originally installed it. SIM 5.0 and SQL Server are on the same server.

VPM (Vulnerability and Patch Management) is running in a named instance.

[Jeff Rostis]

I just tried removing the server from the domain. A fresh 'typical' install of SIM with the desktop engine worked. Perhaps it is an issue with network security policies, as suggested above?

So I can install SIM this way, but it doesn't really help me since I need it on the domain to use an SQL server on the domain...

[Dmitry_70]

Ok, finally everything's done. There were two causes: unacceptable symbols and default port value for communication with MS SQL Server 2000. Installation continued without "invalid credentials" after changing port value to 1453 and password to "aaaaaa".
After successful installation I changed back port value to default 1433. SIM worked fine. But when I changed password to another even simple password (for example, "aaa"), the SIM service stopped starting with the following message in the event log: com.xp.mx.database.DbVerificationException: Error loading database verification handler 'com.xp.mx.database.MSSQLVerificationException' com.xp.mx.database.DbVerificationException: Error accessing database.
I changed password in the Active Directory and in the "Log on as" services properties.
So, the question is: can I change my password without reinstalling SIM?
BTW: in the Log subfolder of the SIM folder in some log files I see the following strings: Database initialization failed for URL: jdbc.jtdc.sqlserver://:/Insight_v50_0_; domain=; instance=Ex: java.sql.SQLException: Network error IOException: Connection refused: connect.

[tmagee]

I too have now been able to install sim 5.0. My setup has W2k with originally sim 4.2 and MSDE on same server as sim and server on a workgroup not a domain.

Doing Typical install initially wasn't possible due to seemingly wrong password for a valid installer user. Tried through Custom install of just sim homepage and Sim 5.0. When prompted for database credentials, still not accept valid user. Tried changing port to 1453 but no help, put back to 1433. Host name was automatically showing in lower case so set this to all upper case. It then prompted that SVRNETCV.exe needs to be run to setup tcp/ip (see sim install guide for upgrading to sim 5.0). After running this, install continued and installed ok.

Don't know if running the svrnetcv.exe before Typical install would have been enough or the upper case name change is also required.

Now getting homepage and PMP install issues from the cd (can't find setup files but I'll use another post if no resolve on these).

[Darrin Rawls]

In the HP SIM 5 readme should be information around Windows 2000 specificially and having to run that utility to enable TCP/IP (rather than named pipes). That's all you need to do; although you are done now. :)

[Stephen Schramm]

Actually the spelling of the utility is SVRNETCN.exe.

I have been fighting with this for a couple of days and this made it all go away.

Thanks.