topic Re: SIM Upgrade from 4.X to 5 SP5 Database Issue in Server Management - Systems Insight Manager

SIM Upgrade from 4.X to 5 SP5 Database Issue

Steve Anschutz_1 — Thu, 26 Oct 2006 12:59:25 GMT

I'm trying to do the upgrade to 5 and right away I'm failing at the database configuration page with a credentials error. The username that's shown on this page is undefined and is greyed out. Now I'm pretty sure the MSDE database uses sa as the admin account and the database.props file shows hp.Database.adminUser=sa. I'm not sure what account the sim service is running under, but it is currently functioning. How do we get past this credentials issue?

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Daniel Leblanc — Thu, 26 Oct 2006 13:20:49 GMT

Look at this document first if something missing.
http://docs.hp.com/en/5991-4498/ch08.html

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Daniel Leblanc — Thu, 26 Oct 2006 13:25:00 GMT

Are you using a domain account when installing SIM 5 or a local administrator account?

Is the SQL server in the same domain as the SIM server?

Are you using the MSDE installation on the local server or a remote SQL server?

Is the database server you are connecting to a named instance?

Do you have port 1434 blocked in your network? If so, you may need to go into MSDE client config (cliconfg.exe) and manually set the port of your named instance in order to connect.

Have you tried creating a trusted DSN connection to your MSDE using your installation account to make sure that you have access to the MSDE and to the master database on that server? What were the results of this test?

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Daniel Leblanc — Thu, 26 Oct 2006 13:26:25 GMT

For those using Named Pipes and not TCP/IP (like in MSDE), you can change it using C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe. FYI

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Daniel Leblanc — Thu, 26 Oct 2006 13:44:08 GMT

look a these article:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=948745

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=956754

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Steve Anschutz_1 — Thu, 26 Oct 2006 14:00:49 GMT

Tried both a domain account and the local administrator acount (the local admin account may have had it's name changed since the install). The database is on the same server as sim and is MSDE.

I'll give this stuff a read and get back to the forum as soon as possible. Thanks

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Steve Anschutz_1 — Fri, 27 Oct 2006 11:34:08 GMT

Turned on the debug registry keys and checked the hpsim.log file. Here appears to be the spot of the error.

[Fri Oct 27 11:28:07 CDT 2006]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 "MNNCPOBSIM2001" -pn "1433" -db "master" -u "%117%110%100%101%102%105%110%101%100" -dm "LocalSystem" -debug
[Fri Oct 27 11:28:08 CDT 2006]Install Shell:CheckDBServerComplete()
[10-27-2006][11:28:10][Install Shell]The specified database account credentials are not valid.

The -u name looks to be ascii for "undefined". Is that right, should this be undefined?

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Daniel Leblanc — Fri, 27 Oct 2006 11:44:45 GMT

Yap you 're right it should be define

Re: SIM Upgrade from 4.X to 5 SP5 Database Issue

Steve Anschutz_1 — Wed, 08 Nov 2006 08:59:16 GMT

Figured it out, changed the SIM service to run from an account we use for services and that account appeared in the dialog box and accepted the password. Install went fine from there on.