This is the process for re-targeting a Database in the OpenManage Essentials management console.

1. Backup Database – OMEssentials DB(where OME was installed)

2. Copy the DB to another server

3. Restore DB (this can be performed only by a sysadmin)

4. Create a new user with “db_owner” , “sysadmin” and “public” privileges

 

 

 

5. On the system where OME is installed, enter following commands

• sqlcmd /E -Q "select name from sys.syslogins"
• sqlcmd /E -Q "ALTER LOGIN [OMEService] WITH PASSWORD='DummyPassword'"

 

6. Launch OME

7. Database login error displayed. Click OK

 

.

 8. DB Connection error window is displayed.

 

9. Enter server name where OME DB was restored.  Also enter username and password of the new user(that was created in step 4)

10. Launch OME

11. Reset IIS

12. Restart OME services (or restart server)

13. Change the user privileges from sysadmin to dbowner. (This is done on the server where was DB was restored).

 

Note: You may delete the DB where OME was installed after the retarget is complete