- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- HP SIM 7.5 on SQL 2008 R2 SP3
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-23-2015 03:15 AM
10-23-2015 03:15 AM
HP SIM 7.5 on SQL 2008 R2 SP3
Hi. Currently using HP SIM 7.2 on SQL 2008 R2 SP3. Want to update to 7.5. Will it work on this version of SQL as I only see 2012 and 2014 in the release notes? Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2015 04:04 AM
10-23-2015 04:04 AM
Re: HP SIM 7.5 on SQL 2008 R2 SP3
Sure you can ignore the warning during install but when you run into issues this will be the first thing people and HP will point to.
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2015 05:17 AM
10-23-2015 05:17 AM
Re: HP SIM 7.5 on SQL 2008 R2 SP3
Thanks Andrew
What happens to the existing SQL database if I use SQL light version packed with the installer? Will I have to start all over again with discoveries etc etc?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2015 07:22 AM - edited 10-23-2015 07:25 AM
10-23-2015 07:22 AM - edited 10-23-2015 07:25 AM
Re: HP SIM 7.5 on SQL 2008 R2 SP3
Is the current sql also on the SIM server and was it a part of the initial SIM setup or is this a seperate full or express installation of SQL?
If you update an existing setup you will keep the content of the database. If you switch from a remote 2008 SQL to a local express bundeld with the 7.5 SIM package you could try to import the database to the new SQL but re running the discovery should not be a big challenge.
If you would like to leave the data intact you would need to move the database first and then reconfigure SIM to use the new database location and then run the 7.5 update. If you need more info on the reconfigure tool let me know.
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2016 06:46 AM
03-30-2016 06:46 AM
Re: HP SIM 7.5 on SQL 2008 R2 SP3
Can you simply move the DB from an SQL 2008 R2 DB to a SQL 2014 Server and then point the odbc connection there and upgrade then to 7.5 or so you need to export the DB first with the HP Insight manager tools?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2016 12:03 PM
03-30-2016 12:03 PM
Re: HP SIM 7.5 on SQL 2008 R2 SP3
I'm not a SQL expert so i'm not sure, when changing the servername don't forget the portnumber for the new SQL.
Andrew