Re: HELP: move SQL2Ksp4 Database to another 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=NewDBServerNamehp.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 modify6d) change Password Key to MxDBUserPassword6e) Type and confirm the password of the dedicated AD Service Account.6f) Click Modify6g) Click Close

The Application should now work using the Database on the NewDB server.