HPSIM 5 failed to install..

[Fab_3]

I try to migrate from 4.2 to 5.0 but when type "database host and credential" i receive this error message: unable to connect to specify host, please check host, database and port value provided. Port is 1433 (default).
Host name is correct. Database name is "master" (default). I have a little doubt about credential... how can i check account in SQL? Any idea ?

[Aravindh Rajaram · Accepted solution]

You can verify it by creating a system DSN.

[Fab_3]

If i try to connect database launch sqlmaint command with options -U domain\user and -P password receive a "login failure".

Without options above i can connect to database "Logged on to sql server (xxxxxx) as domain\user (trusted). Obviously domain\user are the same....

At this point i haven't any idea to resolve my trouble...

[Aravindh Rajaram]

Do you have any special characters in your passwords? There is a problem upgradeing if you use certain special characters in your passwords.

[Jason Cobb]

I had the same problem. In the begining of the upgrade instructions (HP Systems INsight Manager 5.0 Installation and User Guide Part # 5991-2833 - Chapter 7) it tells you that you have to run svrnetcn to add TCP/IP as an allowed protocol for the MSDE install. I followed this step, but failed to read the warning that the tool gives when you do that. The tool tells you that you have to restart MSDE to make the changes take effect. As soon as I stopped and restarted the SQL instance, it worked for me. Good Luck.