topic Re: 7.1 to 7.2 upgrade options greyed out in Server Management - Systems Insight Manager

7.1 to 7.2 upgrade options greyed out

richard wallis — Thu, 08 Oct 2015 11:24:51 GMT

Hi there,

I am trying to upgrade from 71. to 7.2 and under the database configuration section it will allow me to put in a password but instance is greyed out and incorrect showing MSSQLSERVER, with no other option available and the 'use this one' is also greyed out leaving me nowhere to go, if I click next then it fails to connect which is no surprise as I am using SQL Express 2008 R2.

Any ideas on why and what can I do to move forward with this upgrade?

Richard.

Re: 7.1 to 7.2 upgrade options greyed out

Andrew_Haak — Thu, 08 Oct 2015 16:22:20 GMT

Did you use the existing database option during the install/upgrade.

Re: 7.1 to 7.2 upgrade options greyed out

richard wallis — Fri, 09 Oct 2015 10:54:53 GMT

Hi there,

The DB has been moved recently and MSSQLSERVER would match the previous SQL server instance and it would have been upgraded on the old server and not the new.

What do we need to change to allow the upgrade to proceed?

Re: 7.1 to 7.2 upgrade options greyed out

Andrew_Haak — Sat, 10 Oct 2015 16:59:21 GMT

You say the dbs was moved, is it on an other server ?

is it still a sql express ? And still at port 1433?

Can you add a screenshot of the install?

Re: 7.1 to 7.2 upgrade options greyed out

richard wallis — Mon, 12 Oct 2015 08:02:47 GMT

Hi there,

Thanks for your response, yes, it was on a different server and has been moved to a new server with a different SQL Express instance.

The previous instance was MSSQLSERVER on a full blown SQL cluster server, now the DB is on the local machine SQL Express, port still on 1433.

See pic attached.

Richard.

Re: 7.1 to 7.2 upgrade options greyed out

Andrew_Haak — Sat, 17 Oct 2015 08:43:46 GMT

Hello,

You could try to install the management studio to create a user in SQL to use to connect to the default instance. The name you see in the screenshot should not be a problem.

Re: 7.1 to 7.2 upgrade options greyed out

richard wallis — Mon, 19 Oct 2015 10:59:19 GMT

Hi there,

I have tried creating a new user for the DB but it fails with the attached error.

Kind Regards

Richard.

Re: 7.1 to 7.2 upgrade options greyed out

BrianKelly — Mon, 19 Oct 2015 11:40:04 GMT

If you moved the database the new server name, IP and database user have to be exactly the same as the old server.

If not you'll need to run MX commands to reinitialze the database to the new information.

Re: 7.1 to 7.2 upgrade options greyed out

richard wallis — Mon, 19 Oct 2015 13:26:16 GMT

Hi there,

I have added the user into SQL and changed the user login to Insight manager, when the service is started the error appears in the log;

Caused by: java.sql.SQLException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

SQL is running in mixed mode and the ODBC connection is successful using the username password I have set in HP Insight manager.

Is there a way to tell IM not to expect Windows authentication?

Re: 7.1 to 7.2 upgrade options greyed out

Andrew_Haak — Mon, 19 Oct 2015 15:22:35 GMT

You can aldo take a look here :

http://h30499.www3.hp.com/t5/ITRC-HP-Systems-Insight-Manager/HP-SIM-installation-Remote-SQL-database-permissions/td-p/5013047

And look at the user part and database instantie info part