- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- HELP: move SQL2Ksp4 Database to another server?
Server Management - Systems Insight Manager
1752810
Members
5983
Online
108789
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
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
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО01-10-2007 09:32 PM
тАО01-10-2007 09:32 PM
HELP: move SQL2Ksp4 Database to another server?
I have installed and working HP SIM Version: "Systems Insight Manager 5.0 with SP4 - Windows".
The SQL Database and SIM Server have always been the same server.
I detached the DataBases and moved them to a new server.
What i need to know is how to edit the settings on HP SIM so it will look at the database i have moved to the new server?
I have tried editing the database.props file by replacing any word relating to the old server to the new server.
Can anyone help?
Thanks
Barry
The SQL Database and SIM Server have always been the same server.
I detached the DataBases and moved them to a new server.
What i need to know is how to edit the settings on HP SIM so it will look at the database i have moved to the new server?
I have tried editing the database.props file by replacing any word relating to the old server to the new server.
Can anyone help?
Thanks
Barry
- Tags:
- SQL
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2007 06:33 PM
тАО01-11-2007 06:33 PM
Re: HELP: move SQL2Ksp4 Database to another server?
For troubleshooting purposes you can test the connection from ODBC Administrator, using the login for HPSIM databaseconnection and the server settings in database.props
Ole Thomsen
Ole Thomsen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2007 09:28 PM
тАО01-11-2007 09:28 PM
Re: HELP: move SQL2Ksp4 Database to another server?
After Trauling through the forums i found where i was going wrong.
The original install of System Insight Manager was done using the local system account, this is what was preventing the access to the DB on the NewDB server.
Here is an outline guide of what i did.
1) I deleted the ODBC DSN's - tested the app still worked. (As i had read in the forums these are not used).
2) I created a dedicated AD User account, made it a local admin on the HPSIM Server and the NewDB server.
3) Changed the logon of the "HP System Insight Manager" Service to the dedicated AD Service account. Stopped and started the service. - tested the app still worked.
4) Detached the 3 HPSIM SQL Databases, moved them to the NewDB server and attached the databases on the NewDB server.
5) Edit the "c:\Program Files\hp\Systems Insight Manager\config\database.props" file.
CHANGE Server Name:
hp.Database.hostName=NewDBServerName
hp.Database.instance=NewDBServerName\\
CHANGE UserAccount for the Deicated AD Service account:
hp.Database.username=DOMAIN\\AD-SvcAccount
The Tricky Part:
although you have change the hp.Database.username you must set the password for this account. This is where i got stuck and i found the answer in the following forum:
(http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1068939)
In short follow these steps:
6a) from a cmd prompt type: mxpassword -?
This will bring up your options.
6b) from a cmd prompt type: mxpassword -g
This will load the MxPassword App.
6c) slect modify
6d) change Password Key to MxDBUserPassword
6e) Type and confirm the password of the dedicated AD Service Account.
6f) Click Modify
6g) Click Close
The Application should now work using the Database on the NewDB server.
The original install of System Insight Manager was done using the local system account, this is what was preventing the access to the DB on the NewDB server.
Here is an outline guide of what i did.
1) I deleted the ODBC DSN's - tested the app still worked. (As i had read in the forums these are not used).
2) I created a dedicated AD User account, made it a local admin on the HPSIM Server and the NewDB server.
3) Changed the logon of the "HP System Insight Manager" Service to the dedicated AD Service account. Stopped and started the service. - tested the app still worked.
4) Detached the 3 HPSIM SQL Databases, moved them to the NewDB server and attached the databases on the NewDB server.
5) Edit the "c:\Program Files\hp\Systems Insight Manager\config\database.props" file.
CHANGE Server Name:
hp.Database.hostName=NewDBServerName
hp.Database.instance=NewDBServerName\\
CHANGE UserAccount for the Deicated AD Service account:
hp.Database.username=DOMAIN\\AD-SvcAccount
The Tricky Part:
although you have change the hp.Database.username you must set the password for this account. This is where i got stuck and i found the answer in the following forum:
(http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1068939)
In short follow these steps:
6a) from a cmd prompt type: mxpassword -?
This will bring up your options.
6b) from a cmd prompt type: mxpassword -g
This will load the MxPassword App.
6c) slect modify
6d) change Password Key to MxDBUserPassword
6e) Type and confirm the password of the dedicated AD Service Account.
6f) Click Modify
6g) Click Close
The Application should now work using the Database on the NewDB server.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP