- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: 7.1 to 7.2 upgrade options greyed out
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2015 04:24 AM
10-08-2015 04:24 AM
7.1 to 7.2 upgrade options greyed out
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.
- Tags:
- upgrade
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2015 09:22 AM
10-08-2015 09:22 AM
Re: 7.1 to 7.2 upgrade options greyed out
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2015 03:54 AM
10-09-2015 03:54 AM
Re: 7.1 to 7.2 upgrade options greyed out
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2015 09:59 AM
10-10-2015 09:59 AM
Re: 7.1 to 7.2 upgrade options greyed out
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?
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2015 01:02 AM
10-12-2015 01:02 AM
Re: 7.1 to 7.2 upgrade options greyed out
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2015 01:43 AM
10-17-2015 01:43 AM
Re: 7.1 to 7.2 upgrade options greyed out
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.
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2015 03:59 AM
10-19-2015 03:59 AM
Re: 7.1 to 7.2 upgrade options greyed out
Hi there,
I have tried creating a new user for the DB but it fails with the attached error.
Kind Regards
Richard.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2015 04:40 AM
10-19-2015 04:40 AM
Re: 7.1 to 7.2 upgrade options greyed out
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2015 06:26 AM
10-19-2015 06:26 AM
Re: 7.1 to 7.2 upgrade options greyed out
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2015 08:22 AM
10-19-2015 08:22 AM
Re: 7.1 to 7.2 upgrade options greyed out
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
Andrew